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

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

 

 

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *