Drop Table
Important
This documentation has been retired and might not be updated. The products, services, or technologies mentioned in this content are no longer supported. See DROP TABLE.
DROP TABLE [IF EXISTS] [db_name.]table_name
Drop a table and delete the directory associated with the table from the file system if this is not an EXTERNAL
table. If the table to drop does not exist, an exception is thrown.
IF EXISTS
If the table does not exist, nothing happens.