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

Home -> Community -> Mailing Lists -> Oracle-L -> Primary Keys optional?

Primary Keys optional?

From: Stephen Andert <andert_at_gmail.com>
Date: Thu, 17 Aug 2006 09:46:36 -0700
Message-ID: <6d45e210608170946n70f908e2h3d280ac434c51eb@mail.gmail.com>


OK, just starting a new job with more design than I have done in a while. Looking into things, I have been noticing that many tables have no PK. Some have a unique index, but not all.

When I pointed this out to folks (developers) they shrugged and said "if you need a PK, then create one".

So my questions are:

  1. Is it considered acceptable to have a unique index instead of a pk?
  2. What are the circumstances when a table might be allowed to exist without any sort of primary key or unique index? (i.e. temp table, static small table, etc)

Thanks In Advance

-- 
Stephen Andert
http://spaces.msn.com/andert-news/
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 17 2006 - 11:46:36 CDT

Original text of this message

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