Set Primary Key on an already created table

Search Database SQL / Scripts

Help us in improving the repository. Add new Queries/Scripts through 'Submit Database SQL / Scripts ' link.

Database Queries/Scripts

Sample 1. 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}