Re: Foreign key refer to unique constraint????

kuljeet_twtpl_at_hotmail.com (KULJEET) wrote in message news:<febbed51.0401200544.7256a5a2_at_posting.google.com>...
> foreign key also refer to unique constraint.
> (GREAT...)
>
> 1.then table that containt unique constraint act as master table?????
> 2.IS unique constraint will replace with primary key??
> 3.Is unique constraint gives all fuctionality as primary key constraint???
>
> thanks
> kuljeet pal singh

Yes, a FK can refer to a UK or a PK. This is desirable as some table will have both a PK and UK on them and it may be necessary to validate against both.

If this bothers you
What is the difference between a unique index and a unique constraint?

        http://www.jlcomp.demon.co.uk/faq/uk_idx_con.html

HTH -- Mark D Powell -- Received on Wed Jan 21 2004 - 15:55:46 CET