In article <19990924005009.21468.00001618_at_ng-cn1.aol.com>, DRODRIGU1
<drodrigu1_at_aol.com> writes
>
>alter table ORIGINAL_TABLENAME disable primary key cascade;
>
>You should be able to delete the desired rows from your original table.
>However, you need to reinstate all the constraints that were disabled. Since
>there is no cascade for enabling constraints, you will have to enable them
>individually.
>
Won't this result in all those constraints that refer to the now absent
PK values failing to enable? You'd still have to find the offending
values in the child tables and remove them?
Andy
--
Andy Hardy. PGP key available on request
Received on Fri Sep 24 1999 - 04:43:07 CDT
