A primary key can be compound (it can be comprised of multiple columns), but there can only be one primary key per table.
_____ From: first last [mailto:[EMAIL PROTECTED] Sent: Thursday, June 21, 2007 10:25 AM To: derby-user@db.apache.org Subject: Documentation error in Derby Reference Manual ? 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