Martin Reid
mwp.reid at qub.ac.uk
Sat Apr 24 06:24:54 CDT 2004
This is going to make me look stupid again (<:
Does a Unique Constraint equate to a non clustered index??
In the table properties for an upsized table the index property shows a
unique constraint. When I get out the table using the following I get an
indication of a non clustered index.
DBCC TRACEON (3604)
GO
Declare @DBID Int, @TableID Int
Select @DBID = db_id(), @TableID = object_id('testtable')
DBCC ind(@DBID, @TableID, -1)
GO
All the documentation says a non clustered index is created. But if the
wizard creates a unique constraint as opposed to a non clustered index this
I need to know. Or is this the same thing???
Any comments appreciated.
Martin