I'm a bit unclear on the syntax to add a composite (multiple columns)
primary key to a table.  The columns already exist.  Thanks.

Do:

ALTER TABLE tbl ADD CONSTRAINT pk PRIMARY KEY ( col1, col2 )

ALTER TABLE dbo.TableName ADD CONSTRAINT
    PK_ConstraintName PRIMARY KEY NONCLUSTERED
    (
    Col1,
    Col2
    ) ON [PRIMARY]

When in doubt, you can always perform the action in Enterprise Manager
and then look at the change script to help clear up basic syntax
things.

HTH,
Stu

Roughly this at table creation:
CONSTRAINT PK_NameIt PRIMARY KEY CLUSTERED (Column1, Column2, Column3)

Obviously if you need a NONCLUSTERED PK, use that syntax instead.

Mark

Show quoteHide quote

sql weird
NOLOCK
INSERT table (column1, column2) (@variable, '100')
Simple JOIN turned ugly - Help!
Fix Replace function plz!