SQLMemTable: Embedded BDE Alternative
In-Memory SQL Database for Delphi / C++Builder
The DROP TABLE statement is used to delete table from the database.
DROP TABLE table_name [CASCADE | RESTRICT]
CASCADE option forces to drop all other objects in database referencing this table (like foreign key constraints).
Here is an example:
DROP TABLE Test
If the table does not exist, DROP TABLE will not raise an exception.