"Randy Harris" <randy_at_SpamFree.com> wrote in message
news:mzlfb.5646$Hd6.3652502_at_newssvr28.news.prodigy.com...
> I'm sure this is another dumb question, your patience is appreciated.
>
> Should every table in an Oracle database have a Primary Key? What about a
> very small table that is used for a very short list of values?
Is it desirable - absolutely, even lookup tables shouldn't have duplicates
or miss required data. Is it practice, sadly not.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Sat Oct 04 2003 - 15:17:13 CDT
