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