Syntax to set EMPLOYEE_ID as primary key in employee table.
ALTER TABLE EMPLOYEE add CONSTRAINT EMPLOYEE_PK PRIMARY KEY(EMPLOYEE_ID)
Syntax to set 2 fields(EMPLOYEE_ID, FIRST_NAME) as primary key in employee table.
ALTER TABLE EMPLOYEE add CONSTRAINT EMPLOYEE_PK PRIMARY KEY(EMPLOYEE_ID, FIRST_NAME)
Syntax to drop primary key on employee table.
ALTER TABLE EMPLOYEE drop CONSTRAINT EMPLOYEE_PK
Syntax to create EMPLOYEE_REF_ID in INCENTIVES table as foreign key with respect to EMPLOYEE_ID in employee table.
ALTER TABLE INCENTIVES ADD CONSTRAINT INCENTIVES_FK FOREIGN KEY(EMPLOYEE_REF_ID) REFERENCES EMPLOYEE(EMPLOYEE_ID)
Syntax to drop foreign key on employee table.
ALTER TABLE INCENTIVES drop CONSTRAINT INCENTIVES_FK
Facebook Comments