DROP TABLE

Purpose

This statement is used to drop a table in OceanBase Database.

Syntax

DROP {TABLE | TABLES} [TEMPORARY] [IF EXISTS]
table_name [,table_name]...
[RESTRICT | CASCADE]

Parameters

Examples

• Specify IF EXISTS to drop the test1 table.

  obclient> DROP TABLE IF EXISTS test1;
  Query OK, 0 rows affected
  

• Specify IF EXISTS to drop the test1 and test2 tables.

  obclient> DROP TABLES IF EXISTS test1,test2;
  Query OK, 0 rows affected
  

• Do not specify IF EXISTS. If any of the tables to be dropped does not exist, an error is returned.

  obclient> DROP TABLES test1,test2;
  ERROR 1051 (42S02): Unknown table 'test.test2'
  

• Drop the temporary table tset3.

  obclient> DROP TEMPORARY TABLE test3;
  Query OK, 0 rows affected