[SQL] Adding "on delete cascade" to all foreign key constraints

Hello, I was wondering if there's a fast way I can add "on delete cascade" to all foreign key constraints in my database? Maybe a quick update I can make against the catalog possibly? Or is there a way I can query for all foreign key constrains in the database and then I could write up a quick

Re: [SQL] Determining correct table order for insert or drop statements to satisfy foreign keys

Hi Aaron, I'm using PHP5 as the programming language. Thanks, Pete On Thursday 02 November 2006 16:58, Aaron Bono wrote: > On 11/2/06, Peter Hanson <[EMAIL PROTECTED]> wrote: > > Hello, > > > > First, sorry if this has already been covered, though I didn't

[SQL] Determining correct table order for insert or drop statements to satisfy foreign keys

Hello, First, sorry if this has already been covered, though I didn't find anything similar in the archives. Also sorry if this is the wrong list for this type of question, though it seemed to be the most relevant list for this question. On to the question: I'm writing a simple import script t