Why NULL values in sys.indexes

  • Hi,

    I queried the sys.indexes on a old DB. In the name column of this table i found NULL value.I am not able to understand how did the NULL value crept into this table or it is a normal behavior.

  • Null in the name means its a heap, as a heap doesnt have an index name, it shows as NULL

    Do you get anything from the below query

    SELECT * FROM sys.indexes WHERE name IS NULL and type <> 0

  • anthony.green (1/16/2013)


    Null in the name means its a heap, as a heap doesnt have an index name, it shows as NULL

    Do you get anything from the below query

    SELECT * FROM sys.indexes WHERE name IS NULL and type <> 0

    No i did not get any data .

  • That would indicate that all your indexes have a name. The NULL values are for tables which do not have a clustered index and are heaps.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply