Menu
Amazon Athena
User Guide

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;

On this page: