- 6 When Defining The Foreign Key Constraint See The Partial Code Given Below Why We Only Specify On Delete And Or 1 (108.96 KiB) Viewed 46 times
6. When defining the Foreign Key constraint (see the partial code given below), why we only specify "ON DELETE" and/or "
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
6. When defining the Foreign Key constraint (see the partial code given below), why we only specify "ON DELETE" and/or "
6. When defining the Foreign Key constraint (see the partial code given below), why we only specify "ON DELETE" and/or "ON UPDATE" but do not specify "ON INSERT"? Explain. [1 mark] CREATE TABLE EMPLOYEE ( FOREIGN KEY(Dno) REFERENCES DEPARTMENT(Dnumber) ON DELETE SET DEFAULT ON UPDATE CASCADE) ;