Amazon Athena
User Guide  | API Reference

SHOW CREATE TABLE

Analyzes an existing table named table_name to generate the query that created it.

Synopsis#

SHOW CREATE TABLE [db_name.]table_name

Parameters#

TABLE [db_name.]table_name
The db_name parameter is optional. If omitted, the context defaults to the current database.

Examples#

SHOW CREATE TABLE orderclickstoday;

SHOW CREATE TABLE salesdata.orderclickstoday;