Database SQL / Scripts for '#Add Primary Key Constraint'

Database SQL / Scripts for '#Add Primary Key Constraint' - 2 Query/Script(s) found

Sample 1. Add Primary Key constraint to a Table

ALTER TABLE TABLE_NAME

ADD CONSTRAINT CONSTRAINT_NAME primary key (COLUMN_NAME);

_{Like Feedback Add Primary Key Constraint Constraint Alter Table Alter ADD CONSTRAINT DDL}

Sample 2. Set Primary Key on an already created table

ALTER TABLE EMPLOYEE

ADD CONSTRAINT EMPLOYEE#ID_PRIMARY_KEY

PRIMARY KEY (ID);

_{Like Feedback set primary key after table creation add primary key constraint}

Search Database SQL / Scripts