cascade delete on all tables

[leonard905]

Hi all,
I would like to cascade all delete commands on my tables. When I checked user_constraints.delete_rule the value is set at "NO ACTION". What must I do (please include commands) to cascade delete operations on all the tables.

Thanks in advance
Leonard905

[np70]

Hi,

When You define constraint, you can specify clause
ON DELETE CASCADE. This will delete all dependent rows in
child table when you remove referenced row in parent table.

np70

[leonard905]

I understand that. What I need is how to add the cascade clause to existing constraints.

Thanks

[np70]

I am not sure, but AFAIK you can't change existing constrain
on column. To change constraint, I usually drop and recreate
constraint when nobody is using these tables.

HTH

np70