List of all Tables without Indexes in SQL

How to get the list of all tables that are not having any indexes on them :

Today, I got a question on this and decided to put the way here also. 

SELECT [name] AS Tables_Without_Indexes
FROM sys.tables

WHERE OBJECTPROPERTY(OBJECT_ID,'IsIndexed') = 0

ORDER BY 1;

The above statement will give the tables that are not having any indexes as :

 

Thanks for reading :)

P.S. : How to get list of all Indexes of a table in MS-SQL

Share on Google Plus

About Unknown

A social executive and programmer by passion. He contributes in technical forums along with Career Advice on many websites. Read More ...

---

Join him on : Google+ | Facebook | Twitter