Question

write the query to add the primary key constraint to EmpID column of the employee table

Answer 1

"The answer to the question, ""write the query to add the primary key constraint to EmpID column  of the employee table given"" is as following

To create a PRIMARY KEY constraint on existing table “EMPLOYEE” on ""EMPID"" column and currently column does not contain any value  is:

Alter table EMPLOYEE Add Constraint PK-EMPID Primary Key (EMPID) "

Answer 2

Answer:

ALTER TABLE EMPLOYEE ADD PRIMARY KEY(EMPID);