Re: Primary Key and and Index

A primary key MUST have an index. An index does not have to have a matching constraint. If you create aprimary key without storage constraints, it creates an index in your default tablespace with default storage. And anytime a Primary Key is disabled, the matching index is dropped. So, you can leave the constraint alone, but rebuild the index.

Alan V.

George Meltser wrote in message <6gt4ol$8up$1_at_as1000.javanet.com>...
>The main difference is that a primary key may be disabled and enabled,
while
>an index must be dropped and recreated.
>
>Pete Cruz wrote in message <352d395a.325168_at_news.us.dell.com>...
>>I just wanted to know the difference between a Primary key and a
>>unique indexed column.
>>
>>Thanks
>>
>
>
Received on Mon Apr 13 1998 - 14:44:36 CDT