Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unique Key Constraint
Greg wrote:
> 1. A table can only have 1 primary key (which is always unique)
> 2. A table can have 1 or more unique index keys but still only 1
> primary key.
>
just a minor terminology nitpik
a table can have one Primary key
a table can have one of more Foreign Keys
a table can have one or more unique Constraints
I don't think there is such a thing as a Unique key
Ed Received on Fri Jun 23 2006 - 12:29:29 CDT