DROP TABLE - Amazon Athena
SynopsisParametersExamples
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

DROP TABLE

Removes the metadata table definition for the table named table_name. When you drop an external table, the underlying data remains intact.

Synopsis

DROP TABLE [IF EXISTS] table_name

Parameters

[ IF EXISTS ]

Causes the error to be suppressed if table_name doesn't exist.

Examples

DROP TABLE fulfilled_orders
DROP TABLE IF EXISTS fulfilled_orders

When using the Athena console query editor to drop a table that has special characters other than the underscore (_), use backticks, as in the following example.

DROP TABLE `my-athena-database-01.my-athena-table`

When using the JDBC connector to drop a table that has special characters, backtick characters are not required.

DROP TABLE my-athena-database-01.my-athena-table