Firing Order For Referential Integrity Delete
Started by CNover 23 years ago1 messagesgeneral
Hi!
Is it guaranteed or not to delete the rows from referencing table
before referenced table when referential integrity constraint is
applied? For example:
CREATE TABLE MasterTable (mc1 TEXT PRIMARY KEY, mc2 int);
CREATE TABLE DetailTable (
dc1 TEXT
,dc2 TEXT
,PRIMARY KEY (dc1,dc2)
,CONSTRAINT MyConstraint FOREIGN KEY (dc1) REFERENCES MasterTable
(mc1)
);
Will the rows in DetailTable be deleted before that in MasterTable
having the same value in mc1 as dc1?
If the answer is negative, then my next question would be:
"Is there any plan to implement this feature?"
Thank you in advance for any instruction!
CN