[Q] Foreign Keys

From: Byron Pearce <bpearc1_at_abacus.tis.tandy.com>
Date: 10 Jan 1995 22:35:20 GMT
Message-ID: <3ev238$5ea_at_abacus.tis.tandy.com>

I am trying to write a utility that will generate the CREATE script for all of the tables, views, indexes, etc. within the database. I have run into a problem that I am seeking some assistance on:

All of my information is coming from the "DBA" views. I am trying to declare out-of-line constraints for each table, and this works fine for all constraints except for FOREIGN KEY.

I know that the table name and the name of the foreign key constraint are kept in the R_OWNER R_CONSTRAINT_NAME columns, but where is the name of the column on the referenced table that the FOREIGN KEY is referencing?

I would appreciate any assistance in this matter.

Thanks!

---

Byron Pearce                        |  The thoughts and views herein do not
Tandy Information Services          |  necessarily reflect that of Tandy
byron.pearce_at_tandy.com              |  Corporation.
------------------------------------------------------------------------------

"It's hard to be a ninja when you wear a beeper."

---

Received on Tue Jan 10 1995 - 23:35:20 CET