.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 String The database that the table belongs to.
Folder String The table's folder.
DocString String A string documenting the table.
TotalExtents Int64 The total number of extents in the table.
TotalExtentSize Double The total size of extents (compressed size + index size) in the table (in bytes).
TotalOriginalSize Double The total original size of data in the table (in bytes).
TotalRowCount Int64 The total number of rows in the table.
HotExtents Int64 The total number of extents in the table, stored in the hot cache.
HotExtentSize Double The total size of extents (compressed size + index size) in the table, stored in the hot cache (in bytes).
HotOriginalSize Double The total original size of data in the table, stored in the hot cache (in bytes).
HotRowCount Int64 The total number of rows in the table, stored in the hot cache.
AuthorizedPrincipals String The table's authorized principals, serialized as JSON.
RetentionPolicy String The table's effective* retention policy, serialized as JSON.
CachingPolicy String The table's effective* caching policy, serialized as JSON.
ShardingPolicy String The table's effective* sharding policy, serialized as JSON.
MergePolicy String The table's effective* merge policy, serialized as JSON.
StreamingIngestionPolicy String The table's effective* streaming ingestion policy, serialized as JSON.
MinExtentsCreationTime DateTime The minimum creation time of an extent in the table (or null, if there are no extents).
MaxExtentsCreationTime DateTime The maximum creation time of an extent in the table (or null, if there are no extents).
RowOrderPolicy String The table's effective row order policy, serialized as JSON.

* Taking into account policies of parent entities (such as database/cluster).

Output example

TableName DatabaseName Folder DocString TotalExtents TotalExtentSize TotalOriginalSize TotalRowCount HotExtents HotExtentSize HotOriginalSize HotRowCount AuthorizedPrincipals RetentionPolicy CachingPolicy ShardingPolicy MergePolicy StreamingIngestionPolicy MinExtentsCreationTime MaxExtentsCreationTime
Operations Operations 1164 37687203 53451358 223325 29 838752 1388213 5117 [{"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 } { "DataHotSpan": "4.00:00:00", "IndexHotSpan": "4.00:00:00", "ColumnOverrides": [] } { "MaxRowCount": 750000, "MaxExtentSizeInMb": 1024, "MaxOriginalSizeInMb": 2048 } { "RowCountUpperBoundForMerge": 0, "MaxExtentsToMerge": 100, "LoopPeriod": "01:00:00", "MaxRangeInHours": 3, "AllowRebuild": true, "AllowMerge": true } null
ServiceOperations Operations 1109 76588803 91553069 110125 27 2635742 2929926 3162 [{"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 } { "DataHotSpan": "4.00:00:00", "IndexHotSpan": "4.00:00:00", "ColumnOverrides": [] } { "MaxRowCount": 750000, "MaxExtentSizeInMb": 1024, "MaxOriginalSizeInMb": 2048 } { "RowCountUpperBoundForMerge": 0, "MaxExtentsToMerge": 100, "LoopPeriod": "01:00:00", "MaxRangeInHours": 3, "AllowRebuild": true, "AllowMerge": true } null 2018-02-08 15:30:38.8489786 2018-02-14 07:47:28.7660267