SHOW CREATE TABLE
SHOW CREATE TABLE returns the SQL used to create the table.
Syntax
SHOW [REDACTED] CREATE TABLE <table_name>
| Option | Description |
|---|---|
| REDACTED | If specified, literals will be redacted. |
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:
USAGEprivileges on the schema containing the table.