Drop the specified table.
DROP TABLE [IF EXISTS] tbl_name [FORCE]
tbl_nameis the name of a table in a MemSQL database.
- This command must be run on the master aggregator node (see Node Requirements for MemSQL Commands).
- If there is a view which depends on a table, the table cannot be dropped. See CREATE VIEW for more information.
- By default, the
DROP TABLEcommand waits for the running queries to finish before dropping the table. To override this behavior and kill any running queries, use the
- Table memory can be freed when the
DROP TABLEcommand is run. For information on when/how much table memory is freed when this command is run, see Memory Management.
memsql> DROP TABLE IF EXISTS mytbl;
memsql> DROP TABLE IF EXISTS tab1 FORCE;