On this page
Drop the specified table.
DROP [TEMPORARY] TABLE [IF EXISTS] <table_name> [FORCE];
<table_is the name of a table in a SingleStore database.
This command can be run on the master aggregator node, or a child aggregator node (see Node Requirements for SingleStoreDB Commands ).
This command causes implicit commits.
See COMMIT for more information.
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 TABLEcommand waits for the running queries to finish before dropping the table.
To override this behavior and kill any running queries, use the
Table memory can be freed when the
DROP TABLEcommand is run.
For information on when/how much table memory is freed when this command is run, see Managing Memory.
DROP TEMPORARY TABLEdoes not perform a
COMMITwhen run; issue a
DROP TEMPORARY TABLEif there are uncommited statements.
Because temporary tables only exist for the duration of a client session, no access privileges are required to run
DROP TEMPORARY TABLE.
Unlike when running the
DROP TABLEcommand, running the
DROP TEMPORARY TABLEcommand does not commit implicitly.
DROP TEMPORARY TABLEcannot drop global temporary tables.
A temporary or global temporary table can be dropped using
DROP TABLEwithout specifying the
Refer to the Permission Matrix for the required permission.
DROP TABLE IF EXISTS mytbl;
DROP TABLE IF EXISTS tab1 FORCE;
Last modified: July 20, 2023