.show table schema command

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

Permissions

You must have at least Database User, Database Viewer, or Database Monitor permissions to run these commands. For more information, see role-based access control.

Syntax

Get the schema to use in create/alter commands and additional table metadata:

.show table TableName cslschema

Get the schema in JSON format and additional table metadata:

.show table TableName schema as json

Learn more about syntax conventions.

Parameters

Name	Type	Required	Description
TableName	string	✔️	The name of the table for which to show the schema.

Returns

Output parameter	Type	Description
TableName	string	The name of the table.
Schema	string	The table schema either as should be used for table create/alter or in JSON format
DatabaseName	string	The database to which the table belongs
Folder	string	Table's folder
DocString	string	Table's docstring