1.

How To Find Tables Without Indexes?

Answer»

ANSWER : 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,'IsIndexed') = 0
ORDER BY schema_name, table_name;
GO


Discussion

No Comment Found

Related InterviewSolutions