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

Home -> Community -> Usenet -> c.d.o.tools -> Re: multiple primary keys

Re: multiple primary keys

From: Arthur <mechhunter_at_rocketmail.com>
Date: Fri, 29 Sep 2000 16:09:49 GMT
Message-ID: <39d4bea2.21667937@news.iinet.net.au>

On Fri, 29 Sep 2000 12:22:41 +0100, "Grzegorz Dryl" <Grzegorz.Dryl_at_crt.tpsa.pl> wrote:

>
>> I am only new to this but I don't think that you can have more than
>> one primary key per table. In many ways, primary keys are similiar
>> to unique key - although I have yet to know what the main difference
>> between they are.
>
>primary key = unique + not null
>
>

A ha! Thanks! I was thinking about that in the shower.. so you can have a primary key that HAS to be unique. but you can have a unique key that doesn't has to be primary. Received on Fri Sep 29 2000 - 11:09:49 CDT

Original text of this message

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