Title: If you have a foreign key in a CUSTOMER table that references the primary key in a SALESREP table, ... Post by: zmudasam on Feb 13, 2019 If you have a foreign key in a CUSTOMER table that references the primary key in a SALESREP table, the ON DELETE CASCADE syntax means that ________.
• when a CUSTOMER is deleted, that CUSTOMER's SALESREP is also deleted • when a CUSTOMER is deleted, all SALESREPS are also deleted • when a SALESREP is deleted, all CUSTOMERs of that SALESREP are also deleted • when the SALESREP table is dropped, all CUSTOMERs must be deleted Title: If you have a foreign key in a CUSTOMER table that references the primary key in a SALESREP table, ... Post by: Steve Trainer on Feb 13, 2019 Content hidden
Title: If you have a foreign key in a CUSTOMER table that references the primary key in a SALESREP table, ... Post by: zmudasam on Feb 13, 2019 Thank you, thank you, thank you!
|