You are viewing an older version of this section. View current production version.
Drop the specified table.
DROP TABLE [IF EXISTS] tbl_name
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.
memsql> DROP TABLE IF EXISTS mytbl; Query OK, 0 rows affected (0.00 sec)