tencent cloud

Data Lake Compute

SHOW CREATE TABLE

Download
Focus Mode
Font Size
Last updated: 2024-08-07 17:13:07

Description

Supported engines: Presto and SparkSQL
Applicable table: Native and external tables
Purpose: View table creation statements.

Statement

SHOW CREATE TABLE [catalog_name.][db_name.]table_name

Parameter

TABLE [db_name.]table_name
db_name: Database name
table_name: Table name

Example

SHOW CREATE TABLE tbl;




Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback