.show table schema
Gets the schema to use in create/alter commands and additional table metadata.
Requires Database user permission.
.show table TableName cslschema
| Output parameter | Type | Description |
|---|---|---|
| TableName | String | The name of the table. |
| Schema | String | The table schema as should be used for table create/alter |
| DatabaseName | String | The database to which the table belongs |
| Folder | String | Table's folder |
| DocString | String | Table's docstring |
.show table schema as JSON
Gets the schema in JSON format and additional table metadata.
Requires Database user permission.
.show table TableName schema as json
| Output parameter | Type | Description |
|---|---|---|
| TableName | String | The name of the table |
| Schema | String | The table schema in JSON format |
| DatabaseName | String | The database to which the table belongs |
| Folder | String | Table's folder |
| DocString | String | Table's docstring |