So, what is mean?

Long story short,
a table without a clustered index is called Heap. But you can also add non clustered index without a primary key.

You can list all heap tables with the following script.

SELECT SCH.name + ‘.’ + TBL.name AS TableName FROM sys.tables AS TBL INNER JOIN sys.schemas AS…

--

--

Alim Dogan

I am SQL Server Database Administrator. So, I am doing this job and I am enjoying it super.