Re: Views II

Views do *NOT* allow constraints.
You can use a where clause followed by WITH CHECK OPTION, but that is a check constraint only.
Foreign keys are not possible, which is fair, as a view is not a table.

Regards,

Sybrand Bakker, Oracle DBA

"Stephan Moeller" <stmoeller_at_t-online.de> wrote in message news:98af3a$7vr$01$1_at_news.t-online.com...
> if I try
> alter table abc
> add constraint FK_abc foreign key (name)
> references xyz (name)
>
> I got an error. xyz is the view.
>
> Stephan
>
>
Received on Fri Mar 09 2001 - 05:45:52 CST