.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