DROP TABLE
Removes the metadata table definition for the table named table_name. When you drop an external table, the underlying data remains intact because all
tables in Athena are EXTERNAL.
Synopsis
DROP TABLE [IF EXISTS] table_name [PURGE]
Parameters
- [ IF EXISTS ]
-
Causes the error to be suppressed if
table_namedoesn't exist. - [ PURGE ]
-
Applies to managed tables. Ignored for external tables. Specifies that data should be removed permanently rather than being moved to the
.Trash/Currentdirectory.
Examples
DROP TABLE fulfilled_orders;
DROP TABLE IF EXISTS fulfilled_orders PURGE;
