Re: [SQL] Detect referential integrity structure

2009-07-28 Thread Rob Sargent
Perhaps another option: Alter the references to ON DELETE CASCADE as seen here Akos Gabriel wrote: Hi, I've a big/complex database (Adempiere - www.adempiere.org ) where I'd like to delete some rows from some tables (delete a

[SQL] Detect referential integrity structure

2009-07-28 Thread Akos Gabriel
Hi, I've a big/complex database (Adempiere - www.adempiere.org ) where I'd like to delete some rows from some tables (delete a client and its data from the ERP database). All tables are in one schema (adempiere). There are some foreign keys/constraints. I've following options: - disable all const