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.

Example

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