Which ALTER TABLE statement should you use to add a PRIMARY
Which ALTER TABLE statement should you use to add a PRIMARY KEY constraint on the
EMPLOYEE_ID column of the EMPLOYEE table?
Solution
The SQL statement to add the primary key constraint on EMPLOYEE table is as follows:
ALTER TABLE EMPLOYEE
ADD PRIMARY KEY (EMPLOYEE_ID);
here we have added constraint on column EMPLOYEE_ID as PRIMARY KEY in table EMPLOYEE
