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.
Switch services using the Version drop-down list. Learn more about navigation.
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 |