; > From: Michael Fork [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, December 05, 2000 12:25 PM
> > To: Christopher Kings-Lynne
> > Subject: RE: [HACKERS] SQL to retrieve FK's, Update/Delete action, etc.
> >
> >
> > There ya go, I figured it out :) Given
ng to figure out the system tables!
>
> Chris
>
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]]On Behalf Of Michael Fork
> > Sent: Sunday, December 03, 2000 12:23 PM
> > To: [EMAIL PROTECTED]
> > Subject: [HACKERS] SQ
Given the name of a table, I need to find all foreign keys in that table
and the table/column that they refer to, along with the action to be
performed on update/delete. The following query works, but only when
there is 1 foreign key in the table, when there is more than 2 it grows
exponentially