Skip to content

Latest commit

 

History

History
57 lines (37 loc) · 1.54 KB

drop-table.md

File metadata and controls

57 lines (37 loc) · 1.54 KB
Raw
title summary category
DROP TABLE | TiDB SQL Statement Reference
An overview of the usage of DROP TABLE for the TiDB database.
reference

DROP TABLE

This statement drops a table from the currently selected database. An error is returned if the table does not exist, unless the IF EXISTS modifier is used.

By design DROP TABLE will also drop views, as they share the same namespace as tables.

Synopsis

DropTableStmt:

DropTableStmt

TableOrTables:

TableOrTables

TableNameList:

TableNameList

Examples

mysql> CREATE TABLE t1 (a INT);
Query OK, 0 rows affected (0.11 sec)

mysql> DROP TABLE t1;
Query OK, 0 rows affected (0.22 sec)

mysql> DROP TABLE table_not_exists;
ERROR 1051 (42S02): Unknown table 'test.table_not_exists'
mysql> DROP TABLE IF EXISTS table_not_exists;
Query OK, 0 rows affected (0.01 sec)

mysql> CREATE VIEW v1 AS SELECT 1;
Query OK, 0 rows affected (0.10 sec)

mysql> DROP TABLE v1;
Query OK, 0 rows affected (0.23 sec)

MySQL compatibility

  • Dropping a table with IF EXISTS does not return a warning when attempting to drop a table that does not exist. Issue #7867

See also