Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 9.0.0 | 

SHOW CREATE TABLE Statement

Description

When a table name is specified, the SHOW CREATE TABLE statement outputs the CREATE TABLE statement of the table.

Syntax

SHOW CREATE TABLE table_name

Example

SHOW CREATE TABLE nation;

 

  TABLE                 CREATE TABLE

============================================

  'nation'              'CREATE TABLE [nation] ([code] CHARACTER(3) NOT NULL, [name] CHARACTER VARYING(40) NO

T NULL, [continent] CHARACTER VARYING(10), [capital] CHARACTER VARYING(30),  CONSTRAINT [pk_nation_code] PRIM

ARY KEY  ([code]))'