Re: Referential Integrity Using View

From: Mark & Kristi Wagoner <mwagoner_at_iac.net>
Date: Mon, 6 May 2002 15:15:13 -0400
Message-ID: <ab6ko2$17ua$1@genma.iac.net>

Thanks for the info.

I can't use the tables in this case because the view is actually a union of two tables. I am trying to make sure any rows in a third table contain an identifier that is defined in at least one of the other two tables.

I guess I'll have to use a trigger.

"Frank" <fbortel_at_home.nl> wrote in message news:3CD6E271.7080209_at_home.nl...
> Mark & Kristi Wagoner wrote:
>
> > Is there a way to use a view as the target of a foreign key definition?
I
> > created a primary key on my view but, since you must specify the DISABLE
> > clause when creating it, I cannot reference it in a table's foreign key
> > clause. I am using 9.0.1
> >
> > Thanks
> >
> >
> >
>
> Nope - a view is just that: a way of looking at data.
> Define on tables (what's wrong the the tables, used in
> the view?). So: no referential constraints on views
>
Received on Mon May 06 2002 - 14:15:13 CDT