SQL Server HEAP Tables WITH Clustered Index , how is this possible?

Asked Jan 16 '17 at 13:52

Active Jan 16 '17 at 13:55

Viewed 83 times

I have a database that shows a few tables as HEAP, even since I am sure all of them have Clustered indexes and some even have a few Non-Clustered indexes, since a long time ago.

my understanding for HEAP table is : "A heap is a table without a clustered index"

as seen in the image, this tables have a clustered index

heap tables with clustered index

Currently using SQL Server 2014 with Compatibility mode 120

then , why are this tables being shown as heap when they have a clustered index ?

Thanks!

edited Jan 16 '17 at 13:55

Peter B

22,460
5
32
69

asked Jan 16 '17 at 13:52

Carlos García R.

6

Well....am I looking at your image wrong?, it says that the index are non-clustered.... – Lamak Jan 16 '17 at 13:54
2

PK != Clustered index, if that's the bad assumption behind this question... – Damien_The_Unbeliever Jan 16 '17 at 14:00
screw me and my vision ! how could I miss that ! – Carlos García R. Jan 16 '17 at 15:15
you guys are correct, lamark and Damien_the_unbeliever, thanks for your attention, I am laughing at myself now ! – Carlos García R. Jan 16 '17 at 15:15

SQL Server HEAP Tables WITH Clustered Index , how is this possible?

0 Answers0