Re: Surrogate vs. Natural Primary keys

Bruce G. wrote:
> I am stuck in the middle between developers and a DBA. The developers
> feel that every table in a database needs to have a surrogate primary
> key generated by a sequence and a unique index assigned to any possible
> natural keys in order to eliminate redundancy.

The developers are incompetent and should be trained or terminated.

And I'll bet a Starbuck's latte' originally trained in SQL Server.

Ignore them.

-- 
Daniel A. Morgan
University of Washington
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)