List of all Tables without Indexes in MS SQL

5. June 2012 Anil Kumar MS-SQL Comments (0)
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 : 

listOfTablesWithoutIndexes

 
Thanks for reading :)

 

Tags: