Re: Oracle system table
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 29 Jul 2010 02:32:39 +0000 (UTC)
Message-ID: <i2qp87$ijb$1_at_news.eternal-september.org>
On Wed, 28 Jul 2010 10:18:03 -0700, joel garry wrote:
Date: Thu, 29 Jul 2010 02:32:39 +0000 (UTC)
Message-ID: <i2qp87$ijb$1_at_news.eternal-september.org>
On Wed, 28 Jul 2010 10:18:03 -0700, joel garry wrote:
> What exactly is your need? I work on a database that has many tables
> with no primary keys, so the app makes assumptions...
Having tables with no primary keys is usually a sign of poor design, and therefore the application itself is extremely suspicious. When table is created, there must be some kind of criteria for identifying the records and selecting them from the table. That is what the primary keys are for. There has been, as you're probably well aware, a long debate about "natural" vs. "generated" (or "unnatural") primary key. Each approach has its advantages but there must be a primary key for every table.
-- http://mgogala.byethost5.comReceived on Wed Jul 28 2010 - 21:32:39 CDT