.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