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

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 21 Jan 2004 06:55:46 -0800
Message-ID: <2687bb95.0401210655.33cc08d3@posting.google.com>

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 - 08:55:46 CST