Re: references

Giganews Newsgroups
Subject: Re: references
Posted by:  Catherine (catherine.devl…
Date: 8 Dec 2004

Do you mean referential integrity?  You'll need all_cons_columns and
all_constraints.  It involves some complicated joining, and use of both
the constraint_name and r_constraint_name fields of all_constraints.

If you do this a lot, you might want to make a view of it.

Maybe there's an easier way - I'd like to hear from anybody who knows

Good luck,
- Catherine



In response to

references posted by tb on Wed, 8 Dec 2004