In the tree a check box is only displayed when one of these conditions is met
•At the table level there is an index on table
•At the column level there is an index on the column.
If there is no check box this means there is no index on the table and/or column.
Sort by the column Index Clustered Index to identify tables with no clustered index.
In the Example below
•The dbo.HeapTable does not have an index- meaning the table storage is a HEAP
•The HumanResources.Department table has a check box on the table meaning there are indexes on the table. The GroupName and ModifiedDate columns do not have any indexes on those columns.
