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 :

Untitled.png


Thanks for reading :)


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