alter table add key sql server code example

Example 1: alter table add key sql server

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

Example 2: primary key in sql

PRIMARY KEY
   -- unique identifier for the entire row of record in a table
   --  can not be null and must be unique