[AccessD] OT SQL Server

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




More information about the AccessD mailing list