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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » Working with UltraLite Databases » Working with UltraLite tables and columns

Altering UltraLite column definitions Next Page

Dropping UltraLite tables

Dropping a table means that you are deleting it from the database. You can drop any table provided that 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.

Sybase Central

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.

Interactive SQL

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.

  3. See also