Re: parent tables

[Stephan Heinze <Stephan Heinze xcom de>]

On Wed, 09 Feb 2000 17:02:06 Rodrigo Moya Piernavieja wrote:

> No, the only provider that is starting to have this is the postgres server,
> so Vivien is the only one to have an idea on this. But, does Oracle support
> this as well?

you can define foreign keys for a table (a special constraint-type).

for oracle-geeks:

select table_name from all_constraints c, all_constraints p where
c.r_constraint_name = p.constraint_name and c.constraint_type = 'R'

and some more in the where-clause like: c.owner = ... c.table_name = ...

vivien: what i don't know - whats a order of a parent table (the second
column) ???

kind regards

stephan
-------------------------------------------------------------------
"Life is what happens to you while you're busy making other plans."
                                                        John Lennon
-------------------------------------------------------------------