Re: Master/Detail links: Where in system tables???

On Mon, 11 Aug 1997 11:21:48 -0600, stevec_at_zimmer.csufresno.edu (Steve Cosner) wrote:

>I am working on a utility to access a master table and its detail tables
>automatically, so I need to query Oracle's system tables to determine
>which columns are used to link a detail table to its master table. Is
>there such a system table in Oracle that stores this data?
>
>I have little experience with master/detail links and referential
>integrity. Anyone's help will be greatly appreciated!

If your database is built up relationally, you can always use the constraint tables (user_constraints and user_cons_columns) to follow the link between to tables. The constrainttype would then be 'R' from relational.

Hope this helps.

• Martin Jesterhoudt ---
• martinj(replace this by @)worldonline.nl ---

  ---