On Fri, 03 Aug 2001 11:42:57 -0400, Jenna Klein wrote:

>Is there some way of getting a message about the child tables? 
>Especially since I can see that the delete actually happens (by using 
>List). 

Jenna,

What R:Base versions and products are you using?

I don't use CASCADE much, because I have some philosophical 
problems with how it is conceived.

Depending on your R:Base version, instead of CASCADE< you may be 
able to write a stored procedure that finds the foreign keys, deletes the 
FK rows (reporting counts to you), and then deletes the PK rows.

Bill







Reply via email to