db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Douglas Russell <douglas.russ...@comlab.ox.ac.uk>
Subject Re: Documentation error in Derby Reference Manual ?
Date Thu, 21 Jun 2007 21:21:55 GMT
I don't think so. A table can have only one primary key although it  
may be constructed using multiple fields.

Cheers

On 21 Jun 2007, at 21:24, first last wrote:

> Hi,
> A few lines under the heading "Primary key and unique constraints"  
> in the Derby Reference Manual, the documentation says: "A table can  
> have at most one PRIMARY KEY constraint, but can have multiple  
> UNIQUE constraints.".
>
> However more than one primary key is allowed on a table I believe?
>
> http://db.apache.org/derby/docs/dev/ref/rrefsqlj13590.html


Mime
View raw message