Recent Posts

List Heap Tables

Heap table are the tables which they don’t have any  clustered index. : -- List all heap tables SELECT SCH.name + '.' + TBL.name AS TableName FROM sys.tables AS TBL INNER JOIN sys.schemas AS SCH ON TBL.schema_id = SCH.schema_id INNER JOIN sys.indexes AS IDX ON...

read more