SQL KIDS
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment