ASA SQL User's Guide
Working with Database Objects
Working with tables
Altering tables
You can alter tables in Sybase Central on the Columns tab in the right pane. For example, you can add or delete columns, change column definitions, or change table or column properties.
To alter an existing table (Sybase Central)
Connect to the database.
Open the Tables folder.
In the left pane, select the table you want to alter.
Click the Columns tab in the right right pane and make the necessary changes.
TipsYou can add columns by selecting a table's Columns tab and choosing FileYou can delete columns by selecting the column on the Columns tab and choosing File You can copy a column to a table by selecting the column on the Columns tab in the right pane and then clicking the Copy button. Select the desired table, click the Columns tab in the right pane, and then click the Paste button. |
For more information, see ALTER TABLE statement.