Re: Designer 2000 - Foreign Key

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/06/04
Message-ID: <3395c46d.49899003_at_www.sigov.si>#1/1

On Tue, 03 Jun 1997 19:06:14 -0500, Andres Estrada <xenco_at_xenco.com> wrote:

>I have a table and I am trying to create a Foreign Key relationship to a
>VIEW. It's possible ?
>What Do I Need to do ?

You can not create primary key constraint on view nor can you build an index on view, thus you can not create foreign key referencing a view.

But you can create FK referencing a view's source table and then add check constraint to the dependent table with the same restrictions that you would use to build a view on referenced table.

Regards,

---

Jurij Modic                             Republic of Slovenia
tel: +386 61 178 55 14                  Ministry of Finance
fax: +386 61  21 45 84                  Zupanciceva 3

e-mail: jurij.modic_at_mf.sigov.mail.si Ljubljana 1000

---

Received on Wed Jun 04 1997 - 00:00:00 CEST