Sunday, April 13, 2014

How to find tables without Indexes?

Run following query in Query Editor.
USE <database_name>;

GO

SELECT SCHEMA_NAME(schema_id) AS schema_name

,name AS table_name

FROM sys.tables

WHERE OBJECTPROPERTY(OBJECT_ID,'lslndexed') = 0

ORDER BY schema_name, table_name;

GO

No comments:

Post a Comment