DROP TABLE - Data Lake Analytics - Deprecated

本文介紹通過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)