SHOW CREATE TABLE

SHOW CREATE TABLE returns the SQL used to create the table.

Syntax

SHOW [REDACTED] CREATE TABLE <table_name> 

For available table names, see SHOW TABLES.

Examples

CREATE TABLE t (a int, b text NOT NULL); 

SHOW CREATE TABLE t; 

 name | create_sql ----------------------+----------------------------------------------------------------------------------------------------- materialize.public.t | CREATE TABLE "materialize"."public"."t" ("a" "pg_catalog"."int4", "b" "pg_catalog"."text" NOT NULL) 

Privileges

The privileges required to execute this statement are:

• USAGE privileges on the schema containing the table.

Related pages

• SHOW TABLES
• CREATE TABLE