ON DELETE CASCADE

Hi ,
I have created tables in a database . I created referential inegrity constraints for various tables spanning across schemas. How can I change all the constrinst to ON DELETE CASCADE ? Can someone help me with a script ?

Thanks,
Fathima

What exactly do you want to do?

you want to delete data or drop a table?

- magnus

do an alter table on the table on which you would like to set the ON DELETE CASCADE constraint on.

ALTER TABLE table_name MODIFY CONSTRAINT ....

Hope this would help you.

Sam