Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Tables, views, and indexes » Tables » Table alteration


Altering a table

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


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


 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.


The table definition is updated in the database.


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

 See also