Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unique Key Constraint
Ed Prochak wrote:
> 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
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c22integ.htm#2045
<quote>
Unique Keys
The columns included in the definition of the UNIQUE key constraint are
called the unique key. Unique key is often incorrectly used as a
synonym for the terms UNIQUE key constraint or UNIQUE index. However,
note that key refers only to the column or set of columns used in the
definition of the integrity constraint.
</quote>
Received on Fri Jun 23 2006 - 12:41:17 CDT