Feedback Edit

.show table schema

  • Article
  • 2 minutes to read

Gets the schema to use in create/alter commands and additional table metadata.

Requires Database user permission.

.show table TableName cslschema
Output parameter Type Description
TableName String The name of the table.
Schema String The table schema as should be used for table create/alter
DatabaseName String The database to which the table belongs
Folder String Table's folder
DocString String Table's docstring

.show table schema as JSON

Gets the schema in JSON format and additional table metadata.

Requires Database user permission.

.show table TableName schema as json
Output parameter Type Description
TableName String The name of the table
Schema String The table schema in JSON format
DatabaseName String The database to which the table belongs
Folder String Table's folder
DocString String Table's docstring