SHOW CREATE TABLE

Show the definition that creates the specified Nessie table. The output includes two columns:

path: The path to the specified table.

sql_definition: The definition for the specified table.

note

You need the SELECT privilege on the table to retrieve the definition.

Syntax

SHOW CREATE TABLE <table_name>
  [ AT { REF[ERENCE] | BRANCH | TAG | COMMIT } <reference_name> ]

Parameters

<table_name> String

The name of the table whose definition you want to see.

---

AT { REF[ERENCE] | BRANCH | TAG | COMMIT } <reference_name> String   Optional

Specify the reference for which you want to show the table definition:

• REF: Identifies the branch, tag, or commit for the table for which you want to show the available definition.
• BRANCH: Identifies the branch for the table for which you want to show the available definition.
• TAG: Identifies the tag for the table for which you want to show the available definition.
• COMMIT: Identifies the commit for the table for which you want to show the available definition. Commit hashes must be enclosed in double quotes (for example, “ff2fe50fef5a030c4fc8e61b252bdc33c72e2b6f929d813833d998b8368302e2”).

Examples

Show the definition of a Nessie table in a specified branch

SHOW CREATE TABLE "company_data".employees
  AT BRANCH "main"