Contents Index Altering tables Altering tables (SQL)

ASA SQL User's Guide
  Working with Database Objects
    Working with tables
      Altering tables

Altering tables (Sybase Central)

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)

  1. Connect to the database.

  2. Open the Tables folder.

  3. In the left pane, select the table you want to alter.

  4. Click the Columns tab in the right right pane and make the necessary changes.

Tips 
You can add columns by selecting a table's Columns tab and choosing File > Add Column.

You can delete columns by selecting the column on the Columns tab and choosing File > Remove Column.

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.


Contents Index Altering tables Altering tables (SQL)