You can define a composite primary key like this:
DECLARE @MyTable TABLE
(
PersonID INT NOT NULL,
Person2ID INT NOT NULL,
Description NVARCHAR(100),
PRIMARY KEY (PersonID, Person2ID)
);
You can define a composite primary key like this:
DECLARE @MyTable TABLE
(
PersonID INT NOT NULL,
Person2ID INT NOT NULL,
Description NVARCHAR(100),
PRIMARY KEY (PersonID, Person2ID)
);