I have two tables in mysql database- parent, child.i'm trying to add foreign key references to my child table based on the parent table. is there any significant difference between on update cascade and on delete cascade. my parent table. The cascade delete on the foreign key called fk_foreign_comp causes all corresponding records in the products table to be cascade deleted when a record in the supplier table is deleted, based on supplier_id and supplier_name.. Alter table `categories_products` add constraint `constr_categoriesproducts_categories_fk` foreign key `categories_fk` (`categories_id`) references `categories` (`id`) on delete cascade on update cascade, constraint `constr_categoriesproducts_products_fk` foreign key `products_fk` (`products_id`) references `products` (`id`) on delete cascade.
Foreign key constraints are an integral part of sql server database design. these are used to maintain integrity among related data in different tables. while implementing update and delete operations on values in the parent table (referenced table with primary key) we have to consider the impact on. Alter table table_name drop foreign key `fk_name`, add constraint `fk_name2` foreign key (`remote_id`) references `other_table` (`id`) on delete cascade; this is useful to minimize downtime if you have a large table.. How does cascade work in cases of delete/update for foreign key? — shows when record is deleted from parent table it deletes from the table that has foreign key due to “on delete cascade” — shows when update primary key oracle will allow the update to occur on the parent table and then one can update the foreign key sql> update.