Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Dropping UltraLite tables

Dropping a table means that you are deleting it from the database. You can drop any table provided that the table:

• Is not being used as an article in a publication.

• Does not have any columns that are referenced by another table's foreign key.

In these cases, you must change the publication or delete the foreign key before you can successfully delete the table.

You can use either Sybase Central or Interactive SQL to perform this task.

In Sybase Central, you can perform these tasks while working with a selected table.

To delete an UltraLite table (Sybase Central)

1. Connect to the UltraLite database.

2. Open the Tables folder.

3. Select the table and then choose Edit > Delete.

In Interactive SQL, deleting a table is also called dropping it. You can drop a table by executing a DROP TABLE statement.

To delete an UltraLite table (Interactive SQL)

1. Connect to the UltraLite database.

2. Execute a DROP TABLE statement.

   Examples    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 also

• UltraLite DROP TABLE statement