.show table details.show table details

返回一个集合,其中包含指定的表或数据库中的所有表,以及每个表的属性的详细摘要。Returns a set that contains the specified table or all tables in the database with a detailed summary of each table's properties.

需要数据库查看者权限Requires Database viewer permission.

.show table T1 details
.show tables (T1, ..., Tn) details
.show tables details

输出Output

输出参数Output parameter 类型Type 说明Description
TableName 字符串String 表的名称。The name of the table.
DatabaseName StringString 表所属的数据库。The database that the table belongs to.
Folder StringString 表的文件夹。The table's folder.
DocString StringString 一个用来记录表的字符串。A string documenting the table.
TotalExtents Int64Int64 表中的总盘区数。The total number of extents in the table.
TotalExtentSize DoubleDouble 表中的区的总大小(压缩大小 + 索引大小,以字节为单位)。The total size of extents (compressed size + index size) in the table (in bytes).
TotalOriginalSize DoubleDouble 表中数据的原始总大小(以字节为单位)。The total original size of data in the table (in bytes).
TotalRowCount Int64Int64 表中的总行数。The total number of rows in the table.
HotExtents Int64Int64 存储在热缓存中的表中的总盘区数。The total number of extents in the table, stored in the hot cache.
HotExtentSize DoubleDouble 存储在热缓存中的表中的区的总大小(压缩大小 + 索引大小,以字节为单位)。The total size of extents (compressed size + index size) in the table, stored in the hot cache (in bytes).
HotOriginalSize DoubleDouble 存储在热缓存中的表中数据的原始总大小(以字节为单位)。The total original size of data in the table, stored in the hot cache (in bytes).
HotRowCount Int64Int64 存储在热缓存中的表中的总行数。The total number of rows in the table, stored in the hot cache.
AuthorizedPrincipals StringString 表的已授权主体(序列化为 JSON)。The table's authorized principals, serialized as JSON.
RetentionPolicy StringString 表的有效* 保留策略(序列化为 JSON)。The table's effective* retention policy, serialized as JSON.
CachingPolicy StringString 表的有效* 缓存策略(序列化为 JSON)。The table's effective* caching policy, serialized as JSON.
ShardingPolicy StringString 表的有效* 分片策略(序列化为 JSON.66666666666666)The table's effective* sharding policy, serialized as JSON.66666666666666
MergePolicy StringString 表的有效* 合并策略(序列化为 JSON)。The table's effective* merge policy, serialized as JSON.
StreamingIngestionPolicy StringString 表的有效* 流式引入策略(序列化为 JSON)。The table's effective* streaming ingestion policy, serialized as JSON.
MinExtentsCreationTime DateTimeDateTime 表中盘区的最小创建时间(如果没有盘区,则为 NULL)。The minimum creation time of an extent in the table (or null, if there are no extents).
MaxExtentsCreationTime DateTimeDateTime 表中盘区的最大创建时间(如果没有盘区,则为 NULL)。The maximum creation time of an extent in the table (or null, if there are no extents).
RowOrderPolicy StringString 表的有效行顺序策略(序列化为 JSON)。The table's effective row order policy, serialized as JSON.

*考虑父实体(例如数据库/群集)的策略。* Taking into account policies of parent entities (such as database/cluster).

输出示例Output example

TableNameTableName DatabaseNameDatabaseName 文件夹Folder DocStringDocString TotalExtentsTotalExtents TotalExtentSizeTotalExtentSize TotalOriginalSizeTotalOriginalSize TotalRowCountTotalRowCount HotExtentsHotExtents HotExtentSizeHotExtentSize HotOriginalSizeHotOriginalSize HotRowCountHotRowCount AuthorizedPrincipalsAuthorizedPrincipals RetentionPolicyRetentionPolicy CachingPolicyCachingPolicy ShardingPolicyShardingPolicy MergePolicyMergePolicy StreamingIngestionPolicyStreamingIngestionPolicy MinExtentsCreationTimeMinExtentsCreationTime MaxExtentsCreationTimeMaxExtentsCreationTime
操作Operations 操作Operations 11641164 3768720337687203 5345135853451358 223325223325 2929 838752838752 13882131388213 51175117 [{"Type":"AAD User", "DisplayName":"My Name (upn: alias@fabrikam.com)", "ObjectId": "a7a77777-4c21-4649-95c5-350bf486087b", "FQN": "aaduser=a7a77777-4c21-4649-95c5-350bf486087b", "Notes": ""}][{"Type": "AAD User", "DisplayName": "My Name (upn: alias@fabrikam.com)", "ObjectId": "a7a77777-4c21-4649-95c5-350bf486087b", "FQN": "aaduser=a7a77777-4c21-4649-95c5-350bf486087b", "Notes": ""}] {"SoftDeletePeriod":"365.00:00:00", "ContainerRecyclingPeriod":"1.00:00:00", "ExtentsDataSizeLimitInBytes":0, "OriginalDataSizeLimitInBytes":0 }{"SoftDeletePeriod": "365.00:00:00", "ContainerRecyclingPeriod": "1.00:00:00", "ExtentsDataSizeLimitInBytes": 0, "OriginalDataSizeLimitInBytes": 0 } { "DataHotSpan":"4.00:00:00", "IndexHotSpan":"4.00:00:00", "ColumnOverrides": [] }{ "DataHotSpan": "4.00:00:00", "IndexHotSpan": "4.00:00:00", "ColumnOverrides": [] } { "MaxRowCount":750000, "MaxExtentSizeInMb":1024, "MaxOriginalSizeInMb":2048 }{ "MaxRowCount": 750000, "MaxExtentSizeInMb": 1024, "MaxOriginalSizeInMb": 2048 } { "RowCountUpperBoundForMerge":0, "MaxExtentsToMerge":100, "LoopPeriod":"01:00:00", "MaxRangeInHours":3, "AllowRebuild": true, "AllowMerge": true }{ "RowCountUpperBoundForMerge": 0, "MaxExtentsToMerge": 100, "LoopPeriod": "01:00:00", "MaxRangeInHours": 3, "AllowRebuild": true, "AllowMerge": true } Nullnull
ServiceOperationsServiceOperations 操作Operations 11091109 7658880376588803 9155306991553069 110125110125 2727 26357422635742 29299262929926 31623162 [{"Type":"AAD User", "DisplayName":"My Name (upn: alias@fabrikam.com)", "ObjectId": "a7a77777-4c21-4649-95c5-350bf486087b", "FQN": "aaduser=a7a77777-4c21-4649-95c5-350bf486087b", "Notes": ""}][{"Type": "AAD User", "DisplayName": "My Name (upn: alias@fabrikam.com)", "ObjectId": "a7a77777-4c21-4649-95c5-350bf486087b", "FQN": "aaduser=a7a77777-4c21-4649-95c5-350bf486087b", "Notes": ""}] { "SoftDeletePeriod":"365.00:00:00", "ContainerRecyclingPeriod":"1.00:00:00", "ExtentsDataSizeLimitInBytes":0, "OriginalDataSizeLimitInBytes":0 }{ "SoftDeletePeriod": "365.00:00:00", "ContainerRecyclingPeriod": "1.00:00:00", "ExtentsDataSizeLimitInBytes": 0, "OriginalDataSizeLimitInBytes": 0 } { "DataHotSpan":"4.00:00:00", "IndexHotSpan":"4.00:00:00", "ColumnOverrides": [] }{ "DataHotSpan": "4.00:00:00", "IndexHotSpan": "4.00:00:00", "ColumnOverrides": [] } { "MaxRowCount":750000, "MaxExtentSizeInMb":1024, "MaxOriginalSizeInMb":2048 }{ "MaxRowCount": 750000, "MaxExtentSizeInMb": 1024, "MaxOriginalSizeInMb": 2048 } { "RowCountUpperBoundForMerge":0, "MaxExtentsToMerge":100, "LoopPeriod":"01:00:00", "MaxRangeInHours":3, "AllowRebuild": true, "AllowMerge": true }{ "RowCountUpperBoundForMerge": 0, "MaxExtentsToMerge": 100, "LoopPeriod": "01:00:00", "MaxRangeInHours": 3, "AllowRebuild": true, "AllowMerge": true } Nullnull 2018-02-08 15:30:38.84897862018-02-08 15:30:38.8489786 2018-02-14 07:47:28.76602672018-02-14 07:47:28.7660267