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