Altering a table

You can use Sybase Central to alter tables in your database, for example to add or remove columns, or change the table owner.

Prerequisites

You must be the owner, or have one of the following privileges:

ALTER privilege on the table and one of COMMENT ANY OBJECT, CREATE ANY OBJECT, or CREATE ANY TABLE system privileges.
ALTER ANY TABLE system privilege
ALTER ANY OBJECT system privilege
ALTER ANY OBJECT OWNER privilege (if changing the table owner) and one of ALTER ANY OBJECT system privilege, ALTER ANY TABLE system privilege, or ALTER privilege on the table.

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.

Task

In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

Choose one of the following options:

Option	Action
Change the columns	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.
Change the owner of the table	Right-click a table, click Properties » Change Owner Now, and change the table owner.

Results

The table definition is updated in the database.

Next

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

Altering a table

Task

See also