SQL Server: Script to find Heap Table without having an Index

In this post, I am sharing one of the script for a Database Administrator to find SQL Server Heap Tables which are not having a clustered index.

A Table without a cluster index is called as Heap Table and Data is stored in the Heap without specifying an order.

I have also published one article on, What is Heap Table?
You can visit this article here:

Sometimes, database developer forgets to apply cluster index on a particular table and after that the same table may have a lot of data which affect to query performance without having a cluster index.

Below is a script to find all Heap Table of a Database:

Anvesh Patel

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz