RE: [HACKERS] SQL to retrieve FK's, Update/Delete action, etc. (fwd)

2000-12-05 Thread Michael Fork
; > 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

RE: [HACKERS] SQL to retrieve FK's, Update/Delete action, etc. (fwd)

2000-12-04 Thread Michael Fork
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

[HACKERS] SQL to retrieve FK's, Update/Delete action, etc.

2000-12-02 Thread Michael Fork
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