OK, I'm having a brain cramp and can't find an SQL example. I have a table with a PK which has a child table associated with it by a FK. The PK was not created with "ON DELETE CASCADE". What is the proper syntax to modify the PK so that it will delete records in the child table when I purge records from the parent table? ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------