Monday, August 12, 2013

T-SQL script to get list of tables which dont have clustered index





SELECT name AS Table_Name_WithoutClusteredIndex  FROM SYS.TABLES
WHERE OBJECTPROPERTY(OBJECT_ID,'TableHasClustIndex') = 0
ORDER BY NAME
GO

 
 

No comments:

Post a Comment