Drop the specified table.

Syntax

DROP TABLE [IF EXISTS] tbl_name [FORCE]

Remarks

• tbl_name is the name of a table in a SingleStore DB database.
• This command must be run on the master 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 Memory Management.

Example

DROP TABLE IF EXISTS mytbl;

DROP TABLE IF EXISTS tab1 FORCE;

Was this Article Helpful?

Thanks For Your Feedback!