You are viewing an older version of this section. View current production version.

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)