Home » Tutorials » SQL SERVER » Find out all tables without indexes in Sql Server

Find out all tables without indexes in Sql Server

Convert DataTable to JSON in C#
Isolation Levels in Sql Server

Find out all tables without indexes in Sql Server

Hey folks till now we have discussed Performance improvement of cursor SQL Server, User defined functions in sqlKill Processes in sql server 2008, View in sql default constraint in sql , Remove Cross duplicate rows in SQLRecursive SQL Query , Recursive SQL Query-2STUFF and CONCAT in SQLRANK in SQL server , Difference between temporary table and table variable in sql serverUNIQUEIDENTIFIER in SQL ServerRAW Mode with FOR XML , AUTO Mode with FOR XMLEXPLICIT Mode with FOR XML , PATH Mode with FOR XMLOUTPUT Clause in SQL ServerDifference between delete and truncate in sql server etc.

Today we will find out all tables without indexes for particular database in Sql Server.

We all have different myths regarding whether there should be indexes on table or not, but today we will first find out which tables contains how many indexes and then find out all tables which are without indexes in Sql Server.

Tables contains how many indexes


Sample Output:


Find out on which tables don’t have any Clustered and Non Clustered Indexes on tables

We have just added HAVING clause at the end as you can notice.

Let me know if you have any query.



Hello friends, My self Dhruv Sheth, I have more than 6 years of Industrial experience as a Software Developer. In my career I got chance to work with asp.net, c#,Web API, JavaScript, JQuery, WPF, WCF , Windows Application, PostScript, vb.net, GhostScript etc. So I have decided to share my knowledge with everyone and finally I have come up with TechnoThirsty.

Leave a Reply

Your email address will not be published. Required fields are marked *


Time limit is exhausted. Please reload CAPTCHA.

The content is copyrighted to technothirsty.com and may not be reproduced on other websites without permission from the owner.You may contact us using the information below.