SQL Protection


Through code i am trying to script a table that has multiple columns as the primary key

CONSTRAINT col1, col2 PRIMARY KEY doesn't work

and when put primary key after each column that doesn't work either.

Any ideas




Re: Primary Key

Adamus Turner


CREATE TABLE [dbo].MyTest(test1 int not null, test2 int not null)

ALTER TABLE MyTest

ADD CONSTRAINT NEW_PK PRIMARY KEY(test1, test2)

Adamus