Altering a table

You can use Sybase Central to alter tables in your database, for example if you want to add or remove columns.

Prerequisites

You must either be the owner of the table or have DBA authority.

Altering tables fails if there are any dependent materialized views; you must first disable dependent materialized views. Use the sa_dependent_views system procedure to determine if there are dependent materialized views.

Context and remarks

Many.

 Alter a table using Sybase Central

  1. Connect to the database using the SQL Anywhere 12 plug-in

  2. Double-click Tables and double-click the table you want to alter.

  3. In the right pane, click the Columns tab and alter the columns for the table as desired.

  4. Click File » Save.

Results

The table definition is updated in the database.

Next

If you disabled materialized views in order to alter the table, you must re-enable and initialize each one.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1