A
This script will find heap table that doesnot contains cluster and non cluster index is heap table because there is no indexing there on to the table. tables selecta.name, b.object_id, b.object_id ,b.type_desc from sys.tables a inner join sys.indexes b on a.object_id = b.object_id and b.type_desc='HEAP'--
No comments:
Post a Comment