Re: references

From: Catherine <catherine.devlin_at_gmail.com>
Date: 8 Dec 2004 07:18:56 -0800
Message-ID: <1102519136.834413.187890@z14g2000cwz.googlegroups.com>

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 it.

Good luck,
- Catherine
http://profiles.yahoo.com/arcticturtle Received on Wed Dec 08 2004 - 09:18:56 CST