set primary key of sql table code example Example: alter table add key sql server ALTER TABLE Persons ADD CONSTRAINT PK_Person PRIMARY KEY (ID,LastName);