DROP TABLE

DROP TABLE [IF EXISTS] tablename [CASCADE | RESTRICT] [FROM CATALOGUE]

This statement will cause the named table, and its indices, to be deleted. If the FROM CATALOGUE clause is specified then the table's entry will be removed from the catalogue, but the table itself will not be deleted.

If the table does not exist then the statement will fail when executed but if the optional IF EXISTS clause is included then the statement will be successful.

The CASCADE and RESTRICT clause are included for standards compatibility and have no effect. Dropping a table will always drop any associated indexes. You cannot drop a table that has an associated logging table nor can you drop a logging table while still associated with its master table.

Examples

DROP TABLE SL00trans