March 21, 2013 at 11:25 am
CAn you please help me figure this one out??
In MS, I am looking at the table and see no indexes there...
However, running this select and get the following result:
SELECT * FROM SYS.INDEXES I WHERE I.object_id = object_id('TABLENAME')
object_id
927342368
name
NULL
index_id
0
type
0
type_desc
HEAP
is_unique
0
data_space_id
1
ignore_dup_key
0
is_primary_key
0
is_unique_constraint
0
March 21, 2013 at 11:31 am
In the sys.indexes table an index_id of 0 indicates that the table is a heap, no clustered index. An index_id of 1 indicates that there is a clustered index. These two values are mutually exclusive. A table is either a heap or has a clustered index (i.e. the table).
March 21, 2013 at 12:07 pm
thank you
got it
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply