Drop tables

To drop a table (Sybase Central)

Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority or as the owner of the table.
If you are dropping a table on which materialized views depend, disable each materialized view:
1. In the left pane, double-click Views.
2. Right-click the materialized view and choose Disable.
Double-click Tables.
Right-click the table and choose Delete.
Click Yes.

To drop a table (SQL)

Connect to the database as a user with DBA authority, or as the owner of the table.
If you are dropping a table on which materialized views depend, disable each materialized view using the ALTER MATERIALIZED VIEW ... DISABLE statement.
Execute a DROP TABLE statement.

Example

The following DROP TABLE command deletes all the records in the Skills table and then removes the definition of the Skills table from the database.

DROP TABLE Skills;

Like the CREATE statement, the DROP statement automatically executes a COMMIT statement before and after dropping the table. This makes all changes to the database since the last COMMIT or ROLLBACK permanent. The DROP statement also drops all indexes on the table. See DROP TABLE statement.

Discuss this page in DocCommentXchange.