how to modify existing foreign key constraint to on delete cascade
prakashMay 21 2011 — edited May 21 2011Hi all,
What is sql command for existing foreign key constraint to on delete cascade in oracle.
I have tried with following command, please let me know the corrections.
alter table emp11
modify constraint <constraint_name> on delete cascadel ;
Thanks,
P Prakash
Edited by: 833560 on May 21, 2011 5:15 AM
Edited by: 833560 on May 21, 2011 5:27 AM