Heap Table: Table without a clustered index is called Heap Table. You can find out the Heap Table by querying the sys.indexes or sys.partitions against the index_id column.
select OBJECT_NAME(object_id),* from sys.indexes where index_id = 0 Select OBJECT_NAME(object_id),* from sys.partitions where index_id = 0
