Answers for "HOW TO ADD A PRIMARY KEY IN SQLSERVER"

sql server add primary key to existing table with data

ALTER TABLE Production.TransactionHistoryArchive
   ADD CONSTRAINT PK_TransactionHistoryArchive_TransactionID PRIMARY KEY CLUSTERED (TransactionID);

Posted by: Guest on July-22-2020

add primary key to database sql

CREATE TABLE Persons (
    ID int NOT NULL,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int,
    PRIMARY KEY (ID)
);

Posted by: Guest on May-04-2021

Code answers related to "HOW TO ADD A PRIMARY KEY IN SQLSERVER"