You can execute the DROP TABLE statement to delete a table.
If the LindormTable version of your Lindorm instance is later than 2.2.16 and earlier than 2.4.1, you must execute the
OFFLINE TABLEto set the state of a table to offline before you execute the DROP TABLE to delete the table. For more information about the OFFLINE TABLE statement, see OFFLINE TABLE.
In LindormTable 2.4.1 and later versions, the
OFFLINE TABLEstatement is automatically executed before the
DROP TABLEis executed.
drop_table_statement ::= DROP TABLE [ IF EXISTS ] table_name
DROP TABLE dt;
DROP TABLE IF EXISTS dt;
DROP TABLE my_schema.dt;