Name

ü

ü

ü

ü

ü

ü

ü

ü

ü

ü

Instance

Database

Table/view header

Table enabled/disabled state (disabled= clustered index disabled)

Partitioned Table enabled/disabled state (disabled= clustered index disabled)

Temporal Table

In memory table showing durability Blue=Schema and data, red=Schema only

Graph tables node table /edge table

View

Column

Item Count

ü

Count of tables and views in database

ü

Count of tables or views in database

ü

Count of columns in table

Column Type Size

ü

Sum of columns size (ignores LOB eg text, nvarchar(max) etc)

ü

column size (ignores LOB eg text, nvarchar(max) etc)

Row Count

ü

Row count of all tables and views in database

ü

Row count of all tables / views in database

ü

Row count of table

Primary Key Disabled

ü

Count of tables and views in database where the primary key is disabled

ü

Count of table or view in database where the primary key is disabled

ü

=1 to show tables primary key is disabled

Primary Key

ü

Count of tables and views in database having a primary key

ü

Count of tables or views in database having a primary key

ü

PK is Clustered Index

PK is NOT Clustered Index

Primary Key Type

ü

N Order asc,   PK is Clustered Index

N Order desc, PK is Clustered Index

N Order asc,   PK is NOT Clustered Index

N Order desc, PK is NOT Clustered Index

Column Primary details. N is the key position eg. 3 is the 3rd column in the primary key

Primary Key Not Clustered index

ü

Count of tables and views in database where primary key is not a clustered index

ü

Count of table or view in database where primary key is not a clustered index

ü

=1 to show tables primary key is not a clustered index

Column Order

ü

Order of Columns in table/view. Useful when sorting on a different column

Index Clustered Disabled

ü

Count of tables and views in database where clustered index is disabled

ü

Count of table or view in database where clustered index is disabled

ü

=1 to show tables clustered index is disabled

Index Clustered Unique

ü

Count of tables and views in database where clustered index is unique

ü

Count of table or view in database where clustered index is unique

ü

=1 to show tables clustered index is unique

Index Clustered Index

ü

Count of tables and views in database which have a clustered index, or clustered columnstore index

ü

Unique clustered index

Non unique clustered index

Clustered columnstore index        

Count of tables or views in database which have a clustered index, or clustered columnstore index. Note the images are for enabled and disabled states. Disabling a clustered index disables access to the underlying table.

ü

N Order asc, clustered index is unique

N Order desc, clustered index is unique

N Order asc, clustered index is not unique

N Order desc, clustered index is not unique

  Clustered columnstore column

Clustered Index

N is the key position

eg. 3 Index is not unique,ascending order and id the 3rd column in the index

Clustered columnstore index

no number shown, there is no column order

Table Heap

Index Non Clustered

Index Non Clustered Columnstore

Index Hash

Index XML

Index Spatial

ü

Count of  tables in database with index type. Note Table heap is a table without a clustered index

ü

Count of  tables in database with index type. Note Table heap is a table without a clustered index

ü

=1 to show the table is a of that type

Is Include

ü

shows when column is part of the an index include. A check box is only displayed on the column for the index Key not the include part.

In Memory

ü

Count of in memory tables in database

ü

Count of in memory tables in database

ü

shows when in memory table

Fill Factor

ü

Fill factor for clustered index as percentage.

Note

 0% is the same as 100%

 This will not show for heap tables- no clustered index on the table

Is Padded

ü

shows if clustered index is padded

Filegroup

ü

Name

Name

Name

Filegroup. Name of the filegroup name

Partition. Name of the partition function name

File Stream name

Nullable

ü

Column is nullable

Identity Insert

ü

123

Column is identity insert

Data Index Ratio

Total Space

Space Unused

Space Used

Space Index

Space Data

ü

Space of all tables, views and indexes in database

ü

Space of all tables / views /indexes in database

ü

Space of table/indexes