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

Which ALTER TABLE statement should you use to add a PRIMARY KEY constraint on the EMPLOYEE_ID column of the EMPLOYEE table?SolutionThe SQL statement to add the

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site