All Products
Search
Document Center

Data Lake Analytics:DROP TABLE

Last Updated:May 19, 2022

Delete tables

Syntax

  1. DROP TABLE [IF EXISTS] table_name

Example

  1. mysql> drop table primitives_orc;
  2. ERROR 18807 (HY000): DropOperationFailedException:Table 'primitives_orc' was not found.
  1. mysql> drop table if exists primitives_orc;
  2. Query OK, 0 rows affected (0.04 sec)

When a table is deleted, the data file in the OSS instance is not deleted.

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