Permanently remove a table definition and all data in the table from a database.
DROP TABLE table-name
The DROP TABLE statement removes the definition of the indicated table. All data in the table is automatically deleted as part of the dropping process. Also, all indexes and keys for the table are dropped by the DROP TABLE statement.
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 the database includes active queries or uncommitted transactions.
For UltraLite.NET users: 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.