Foreign key refer to unique constraint????

KULJEET

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

Jul 19 '05 #1

Subscribe Reply

11179

Carlos

> foreign key also refer to unique constraint.

(GREAT...)

1.then table that containt unique constraint act as master table?????
Yes.
2.IS unique constraint will replace with primary key??
3.Is unique constraint gives all fuctionality as primary key constraint???

The only diference between PK and UK (besides built-in indexes) is
that UK can contain NULLs, whereas PK cannot. A given table could
contain many rows with a NULL in the UK column (this is, the
'uniqueness' affects only NOT NULL columns).

Regards.

Carlos.

Jul 19 '05 #2

Carlos

> foreign key also refer to unique constraint.

(GREAT...)

1.then table that containt unique constraint act as master table?????
Yes.
2.IS unique constraint will replace with primary key??
3.Is unique constraint gives all fuctionality as primary key constraint???

Jul 19 '05 #3

Mark D Powell

ku***********@hotmail.com (KULJEET) wrote in message news:<fe**************************@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 --

Jul 19 '05 #4

Similar topics

6344

Difference between REFERENCES and FOREIGN KEY

by: Luc Martineau | last post by:

Hello When we create a table, what is the difference between the REFERENCE constraint on column and the FOREIGN KEY constraint on table ? I guess that the FOREIGN KEY constraint assures us...

PostgreSQL Database

42377

Null Foreign Key

by: Bodza Bodza | last post by:

I'm having an argument with an incumbent self-taught programmer that it is OK to use null foreign keys in database design. My take is the whole point of a foreign key is that it's not supposed...

Microsoft SQL Server

3331

Separate foreign keys with shared ID space

by: Robert Brown | last post by:

Let's say I have a type hierarchy: (just an example) the general entity customer: CREATE TABLE customer(customer_id int, customer_name varchar(250), customer_type int) three specific...

Microsoft SQL Server

3154

Data import - foreign key question

by: teddysnips | last post by:

This is a rather abstract question about data design, but I ask it here because a) the database is SQL Server, and b) you're such a learned bunch! Let's assume the classic relation of Customers...

Microsoft SQL Server

1418

Cyclic foreign key dependency & table inheritance

by: Scott Ribe | last post by:

I've got a problem which I think may be a bug in Postgres, but I wonder if I'm missing something. Two tables, A & B have foreign key relations to each other. A 3rd table C, inherits from A. A...

PostgreSQL Database

3762

Using Foreign Key To Ref A Unique Index

by: ken_knee | last post by:

I have a PARENT/CHILD I'm attempting to attach another CHILD to. When I try to add a FOREIGN KEY to the 3rd table referring to CHILD1 (AGTERNS), I get error SQL0573N A column list specified in the...

DB2 Database

2480

NOT foreign key in UDB V8.2 LINUX

by: Bob Stearns | last post by:

For good and sufficient reasons I wish to insure that a primary key of table 1 is not a primary key of table 2. The following does not work: ALTER TABLE IS3.AUCTION_SUPER_CATEGORIES ADD...