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: What is the use of a primary key?

Re: What is the use of a primary key?

From: Larry Coon <larry_at_assist.org>
Date: Mon, 25 Nov 2002 09:21:46 -0800
Message-ID: <3DE25C2A.751E@assist.org>


David Cressey wrote:

> In fact, in Oracle, when you declare a PRIMARY KEY, you get an index on
> that key, like it or not.

Seems odd that you'd have a quibble with this (and it's not just limited to Oracle). Since a primary key must be unique, how else would you want to enforce its uniqueness?

Larry Coon
University of California
larry_at_assist.org
and lmcoon_at_home.com Received on Mon Nov 25 2002 - 11:21:46 CST

Original text of this message

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