SingleStore DB

DROP TABLE

Drop the specified table.

Syntax
DROP TABLE [IF EXISTS] <table_name> [FORCE];
Remarks
  • <table_name> is the name of a table in a SingleStore DB database.

  • This command can be run on the master aggregator node, or a child aggregator node (see Node Requirements for SingleStore DB 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 TABLE command waits for the running queries to finish before dropping the table. To override this behavior and kill any running queries, use the FORCE option.

  • 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 Managing Memory.

Example
DROP TABLE IF EXISTS mytbl;
DROP TABLE IF EXISTS tab1 FORCE;