Monday, August 2, 2010

How to find tables without Indexes?


SELECT SCHEMA_NAME(schema_id) AS schema_name

,name AS table_name

FROM sys.tables

WHERE OBJECTPROPERTY(OBJECT_ID,'IsIndexed') = 0

ORDER BY schema_name, table_name;


Source : http://blog.sqlauthority.com


No comments:

Post a Comment