DROP TABLE keyword
DROP TABLE
is used to permanently delete a table and its contents.
caution
This command irremediably deletes the data in the target table. Unless the table was created in a different volume than the standard, see CREATE TABLE IN VOLUME, in which case the table is only logically removed and data remains intact in its volume. In doubt, make sure you have created backups of your data.
#
Syntax#
IF EXISTSAn optional IF EXISTS
clause may be added directly after the DROP TABLE
keywords to indicate that the selected table should be dropped if it exists.
#
Exampletip
To delete the data inside a table but keep the table and its structure, use TRUNCATE.