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

SQL Anywhere 11.0.0 » UltraLite - Database Management and Reference » UltraLite SQL Reference » UltraLite SQL statement reference


UltraLite DROP TABLE statement

Use this statement to remove a table, and all its data, from a database.

DROP TABLE table-name

The DROP TABLE statement drops the specified table from the database. All data in the table is also removed, as well as any indexes and keys.

UltraLite does not process requests or queries referencing the table, or its indexes, while the DROP TABLE statement is being processed. Furthermore, you cannot execute DROP TABLE when there are active queries or uncommitted transactions.

For UltraLite.NET, you cannot execute this statement unless you also call the Dispose method for all data objects (for example, ULDataReader). See Dispose method.

Statements are not released if schema changes are initiated at the same time. See Schema changes with DDL statements.

See also

The following statement deletes a fictitious table, EmployeeBenefits, from the database:

DROP TABLE EmployeeBenefits;