SQL ADD CONSTRAINT Keyword
ADD CONSTRAINT
The ADD CONSTRAINT
command is used to create
a constraint after a table is already created.
The following SQL adds a constraint named "PK_Person" that is a PRIMARY KEY constraint on multiple columns (ID and LastName):
Example
ALTER TABLE Persons
ADD CONSTRAINT PK_Person PRIMARY KEY (ID,LastName);
Copyright 1999-2023 by Refsnes Data. All Rights Reserved.