.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 |