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

Home -> Community -> Usenet -> c.d.o.server -> Primary key or no primary key

Primary key or no primary key

From: <kshave_at_health.gov.mb.ca>
Date: Thu, 21 Jan 1999 13:56:10 GMT
Message-ID: <787blm$gfe$1@nnrp1.dejanews.com>


When a table is created and a primary key constraint is defined, a unique index is automatically set up for that constraint. Would there be any advantage or disadvantage to simply creating the index yourself and not defining a primary key for the table. A unique index is created in either case.

I've looked through all of Oracle's books and I could not find an answer. Does anybody have any input?

-Keith

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Jan 21 1999 - 07:56:10 CST

Original text of this message

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