Skip to main content

SHOW CREATE TABLE

Shows the CREATE TABLE statement that creates the named table.

Syntax

SHOW CREATE TABLE [database.]table_name

Examples

tip

numbers(N) – A table for test with the single number column (UInt64) that contains integers from 0 to N-1.

SHOW CREATE TABLE system.numbers;
+---------+--------------------------------------------------------------------+
| Table | Create Table |
+---------+--------------------------------------------------------------------+
| numbers | CREATE TABLE `numbers` (
`number` UInt64,
) ENGINE=SystemNumbers |
+---------+--------------------------------------------------------------------+
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today