DROP TABLE

删除表

语法

DROP TABLE [IF EXISTS] table_name

示例

mysql> drop table primitives_orc;
ERROR 18807 (HY000): DropOperationFailedException:Table 'primitives_orc' was not found.

mysql> drop table if exists primitives_orc;
Query OK, 0 rows affected (0.04 sec)

删表不会删除OSS中的数据文件。

mysql> drop table primitives_orc_p;
Query OK, 0 rows affected (0.63 sec)