Re: Referential Integrity thru Views

On Fri, Aug 03, 2001 at 11:35:25PM +0530, some SMTP stream spewed forth:
> Hi,
> Right now, I am enforcing uniqueness in three different tables (Supplier, Customer, Ledger) thru the front-end by checking thru a Union Query. Is it possible to enforce such a uniquenessthru in the DB.
>
> Irrespective of the above, is it possible to have a foreign key check in this (???)

Yes.

If you mean supporting uniqueness in views, you would have to enforce
uniqueness on the underlying tables.
You can do this using "create table ... primary key" and "references"
as well as foreign key triggers.

The documentation is actually quite good on these, IIRC.

> Thanx,
> Kapil

gh
--
What, no one sings along with Ricky Martin anymore?
My kid sister does (but then, she prefers pico to vi ...)
-- Suresh Ramasubramanian, alt.sysadmin.recovery