Oct 29, 2014

Find tables without Indexes

Run following query
USE <your_database_name>; 
GO
SELECT SCHEMA_NAME(schema_id) AS schema_name,name AS tbl_name
FROM sys.tables
WHERE OBJECTPROPERTY(OBJECT_ID,'IsIndexed') = 0
ORDER BY schema_name, tbl_name;
GO