Re: Is a primary key always desired?

From: Paul <paul_at_not.a.chance.ie>
Date: Mon, 15 Dec 2003 22:09:31 -0000
Message-ID: <MPG.1a484177a079b4dd989838@news1.eircom.net>

gooiditweg_at_sybrandb.demon.nl says...

> >You are right, there are small lookup tables that do not require a primary key.

> You can't be serious about this. You don't seem to know anything about
> relational theory. You will inevitably get duplicates in your 'small
> lookup tables' I feel sorry for the company who employed you.

Can't the RI be enforced by triggers if, for some reason, the guy doesn't want to use primary keys? Not saying that it's a good thing, just that it is a possibility - legacy data? Whatever?

Paul...

> Sybrand Bakker, Senior Oracle DBA

-- 

plinehan  x__AT__x  yahoo  x__DOT__x  com

C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro

Please do not top-post.

Received on Mon Dec 15 2003 - 16:09:31 CST