DROP TABLE Command Previous  Top  Next DROP TABLE allows you to remove an existing table. Syntax DROP TABLE [ IF EXISTS ] [ MEMORY ] table_name Description DROP TABLE removes a table. All table data and the table definition are removed, so be careful with this command! DROP TABLE will not return an error or raise exception if the table doesn't exist. IF EXISTS Regardless of this keyword specification, the table will not be dropped, if the table doesn't exist and an exception will not be raised.   MEMORY If MEMORY keyword is specified before the table_name then an in-memory table will be removed, not a disk one.   table_name The name of the table to be removed.   Example: DROP TABLE developers           © 2003 - 2024 ComponentAce  | .net zip component | barcode for .net | delphi zip component | delphi database Dec 03, 2024