.show table schema.show table schema
获取要在 create/alter 命令和其他表元数据中使用的架构。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 |
|---|---|---|
| TableNameTableName | StringString | 表的名称。The name of the table. |
| 架构Schema | 字符串String | table schema as 应该用于表创建/更改The table schema as should be used for table create/alter |
| DatabaseNameDatabaseName | StringString | 表所属的数据库The database to which the table belongs |
| 文件夹Folder | StringString | 表的文件夹Table's folder |
| DocStringDocString | StringString | 表的 docstringTable's docstring |
.show table schema as JSON.show table schema as JSON
获取 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 |
|---|---|---|
| TableNameTableName | StringString | 表的名称The name of the table |
| 架构Schema | 字符串String | JSON 格式的表架构The table schema in JSON format |
| DatabaseNameDatabaseName | StringString | 表所属的数据库The database to which the table belongs |
| 文件夹Folder | StringString | 表的文件夹Table's folder |
| DocStringDocString | StringString | 表的 docstringTable's docstring |