All Products
Search

This Product

    Data Lake Analytics - Deprecated:DROP TABLE

    Document Center

    Data Lake Analytics - Deprecated:DROP TABLE

    Last Updated:Apr 23, 2019

    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)