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

SAP Sybase SQL Anywhere 16.0 » UltraLite - Database Management and Reference » UltraLite database schemas » UltraLite tables and columns

 

Deleting UltraLite tables

You can delete tables when you no longer need them.

Prerequisites

You can drop any table if 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.

 Task
  1. Using Sybase Central, connect to the UltraLite database.

  2. In the left pane, double-click Tables.

  3. Right-click a table and click Delete.

  4. Click Yes.

Results

The table is deleted.

 See also