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
Connect to the database using the SQL Anywhere 12 plug-in
Double-click Tables and double-click the table you want to alter.
In the right pane, click the Columns tab and alter the columns for the table as desired.
Click File » Save.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|