Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: sql tables

Re: sql tables

From: David Cressey <cressey73_at_verizon.net>
Date: Thu, 11 Oct 2007 19:35:10 GMT
Message-ID: <OVuPi.10972$br2.6118@trndny03>

"Roy Hann" <specially_at_processed.almost.meat> wrote in message

news:ds2dnQF3Rrfm0pPaRVnyigA_at_pipex.net...

> "David Cressey" <cressey73_at_verizon.net> wrote in message
> news:2RrPi.10966$br2.10003_at_trndny03...
> >
> > All of the "major" SQL DBMS products permit storing more than one
> > identical
> > row in a table. However, they provide several ways the database manager
> > can
> > protect the database from that event. The simplest is to declare a
> > primary
> > key for the table.
>
> Sadly given that it is now considered "best practice" to blindly and
> automatically attach an entirely spurious unique "primary key" value to
> every row in a table, that would be entirely futile.

Why is is sad? What's wrong with declaring a primary key? Or do mean something else by "attach"?
>
> > This will also, however, protect against inserting two
> > rows that differ, but have identical primary key values. Most often,
> > that
> > coincides with the intent of the manager.
>
> I wonder if you can be that confident about what goes on inside the head
of
> the average (database) manager?
>
> Roy
>
>
Received on Thu Oct 11 2007 - 14:35:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US