What is a table called, if it has no Cluster Index?

Hi

Your question is:
What is a table called, if it has neither Cluster nor Non?cluster Index?

Your answer is:
Unindexed table or Heap

But,
A table doesn't have CLUSTERED Index is called HEAP .

Definition : A table which has Non-Clustered index, will not sort the data Physically.
So the data physically not sorted then it will be called as HEAP structure.
So. The table also called as HEAP even it has Non-Clustered Index.

So, Pl try to change your Question / Answer accordingly. Sorry for this kind of reply.... I am trying to steer right way, not anything else. Pl take it as Optimistic.

Cheers

Hi,

Thanks for bringing into notice. I have modified the question.