Monday, April 18, 2011

How to find tables with no indexes


SELECT Schema_Name(Schema_ID) AS SCH_Name ,Name AS TAB_NAME  FROM SYS.TABLES
WHERE OBJECTPROPERTY(Object_ID, 'IsIndexed') = 0
ORDER BY SCH_Name, TAB_NAME

No comments:

Post a Comment