Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: multiple primary keys
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