adding a composite column constraint
March 16, 2004 04:27 PM
unique constraints are actually implemented as indexes really, so it might not be obvious where to go to do this in enterprise manager.
to add a unique composite column constraint in sql server, you can bring up the design table dialog (right click on the table) in enterprise manager, then click on indexes and keys.
add a new index, and in the table column list
add the columns you want
then select 'create unique', and choose 'constraint'.
in Transact SQL -- it's something like this...
ALTER TABLE [dbo].[mytable] WITH NOCHECK ADD
CONSTRAINT [IX_mytable] UNIQUE NONCLUSTERED
(
[column1],
[column2]
) ON [PRIMARY]
simple no?