sql command to alter primary key adding a clumn from other table code example

Example: alter table add key sql server

ALTER TABLE Persons
ADD CONSTRAINT PK_Person PRIMARY KEY (ID,LastName);