You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

DROP TABLE

Drop the specified table.

Syntax

DROP TABLE [IF EXISTS] tbl_name

Remarks

  • tbl_name is 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.
  • Table memory can be freed when the DROP TABLE command is run. For information on when/how much table memory is freed when this command is run, see Memory Management.

Example

memsql> DROP TABLE IF EXISTS mytbl;
Query OK, 0 rows affected (0.00 sec)