0
ALTER TABLE WORKS_ON ADD constraint 
companyFK3 FOREIGN KEY(Essn) 
REFERENCES EMPLOYEE (Ssn);


ALTER TABLE WORKS_ON  ADD constraint 
companyFK4 FOREIGN KEY(Pno)
REFERENCES PROJECT (Pnumber);

The problem is i don't know how to add CASCADE DELETE FOR it .

Link to DB:https://www.db-fiddle.com/f/xhEj2sAgdTMABBkCtJvmoC/0#&togetherjs=z3CKywAccH

Sukhvinder Kaur
  • 1
  • Possible duplicate of [PostgreSQL: FOREIGN KEY/ON DELETE CASCADE](https://stackoverflow.com/questions/14141266/postgresql-foreign-key-on-delete-cascade) – Bagus Tesa Feb 16 '19 at 16:25

1 Answers1

0
ALTER TABLE WORKS_ON ADD constraint 
companyFK3 FOREIGN KEY(Essn) 
REFERENCES EMPLOYEE (Ssn) ON DELETE CASCADE;


ALTER TABLE WORKS_ON  ADD constraint 
companyFK4 FOREIGN KEY(Pno)
REFERENCES PROJECT (Pnumber) ON DELETE CASCADE;
FXD
  • 1,960
  • 1
  • 6
  • 9
  • almost, i thought its [`DELETE CASCADE`](https://stackoverflow.com/a/14141354/4648586) no? – Bagus Tesa Feb 16 '19 at 10:15
  • Of course it makes sense and is absolutely neccessary to explainyour answer. And if the other question is a duplicate, mark it as a duplicate! – Nico Haase Feb 16 '19 at 11:53