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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy