Contents Index Creating tables Altering tables (Sybase Central)

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

Altering tables


This section describes how to change the structure or column definitions of a table. For example, you can add columns, change various column attributes, or delete columns entirely.

In Sybase Central, you can perform these tasks on the SQL tab in the right pane of Sybase Central. In Interactive SQL, you can perform these tasks with the ALTER TABLE statement.

If you are working with Sybase Central, you can also manage columns (add or remove them from the primary key, change their properties, or delete them) by working with menu commands when you have a column selected in the Columns folder.

For information on altering database object properties, see Setting properties for database objects.

For information on granting and revoking table permissions, see Granting permissions on tables and Revoking user permissions.


Altering tables (Sybase Central)
Altering tables (SQL)

Contents Index Creating tables Altering tables (Sybase Central)