Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: ✅ Azure Data Explorer
Gets the schema to use in create/alter commands and additional table metadata.
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.
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.
| Name | Type | Required | Description |
|---|---|---|---|
| TableName | string |
✔️ | The name of the table for which to show the schema. |
| 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 |