Re: Unique Key Constraint

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.

-Greg
Khurram wrote:
> hi
>
> I read the following Unique key restriction
>
>
> -A table or view can have only one unique key.
>
> From
>
> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/clauses3a.htm
>
> But when i create more then one unique key it let me create is document
> pointing me wrong
> or i am getting wrong inference?
>
> SQL> DROP TABLE t;
>
> Table dropped.
>
> SQL> CREATE TABLE t (a NUMBER UNIQUE,b NUMBER UNIQUE);
>
> Table created.
>
> Khurram
Received on Fri Jun 23 2006 - 11:15:44 CDT