January 16, 2013 at 1:20 am
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.
January 16, 2013 at 1:46 am
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
January 16, 2013 at 2:07 am
anthony.green (1/16/2013)
Null in the name means its a heap, as a heap doesnt have an index name, it shows as NULLDo 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 .
January 16, 2013 at 2:13 am
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