.show table schema command

Applies to: ✅ Azure Data Explorer

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