Friday, 7 November 2014

list all table without clustered index

list all table without clustered index

SELECT DISTINCT [TABLE]=OBJECT_NAME(OBJECT_ID) FROM sys.indexes WHERE index_id=0
AND OBJECTPROPERTY(object_id,'IsUserTable')=1 ORDER BY [TABLE]

No comments:

Post a Comment