Deleting UltraLite tables

You can drop any table if the table:

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.

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

Connect to the UltraLite database.
Execute a DROP TABLE statement.

For example, the following DROP TABLE statement 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 statement makes all changes to the database since the last COMMIT or ROLLBACK permanent. The DROP statement also drops all indexes on the table.