DROP TABLE#

DROP TABLE table_name

The DROP TABLE statement is used to drop a specified table.

Example: Delete a Table in the Current Database#

Create database db1 and set it as the current database:

CREATE DATABASE db1;
-- SUCCEED

USE db1;
-- SUCCEED: Database changed

Create two tables t1 and t2 in the database:

CREATE TABLE t1(col0 STRING);
-- SUCCEED

CREATE TABLE t2(col0 STRING);
-- SUCCEED

View the tables of current database:

SHOW TABLES;
 -------- 
  Tables  
 -------- 
  t1      
  t2      
 -------- 
2 rows in set

Delete table t1:

DROP TABLE t1;
-- Drop table t1? yes/no
-- yes
-- SUCCEED: Drop successfully

Look at the tables of db1 again:

SHOW TABLES;
 -------- 
  Tables  
 --------      
  t2      
 -------- 
1 rows in set