We use the ON DELETE CASCADE clause with a FOREIGN KEY constraint to specify that
when a row in the parent table is deleted, any matching rows in the child table are also deleted.
You use the ON DELETE SET NULL clause with a FOREIGN KEY constraint to specify that
when a row in the parent table is deleted, the foreign key column for the row (or rows) in the
child table is set to null.
Ur's
AmarAlam
when a row in the parent table is deleted, any matching rows in the child table are also deleted.
You use the ON DELETE SET NULL clause with a FOREIGN KEY constraint to specify that
when a row in the parent table is deleted, the foreign key column for the row (or rows) in the
child table is set to null.
Ur's
AmarAlam
0 comments:
Post a Comment