Re: What is the use of a primary key?
From: Lauri Pietarinen <lauri.pietarinen_at_atbusiness.com>
Date: Mon, 25 Nov 2002 20:20:16 +0200
Message-ID: <3DE269E0.1080108_at_atbusiness.com>
Date: Mon, 25 Nov 2002 20:20:16 +0200
Message-ID: <3DE269E0.1080108_at_atbusiness.com>
>
>
>David Cressey wrote:
>
>
>
>>In fact, in Oracle, when you declare a PRIMARY KEY, you get an index on
>>that key, like it or not.
>>
>>
>
>Seems odd that you'd have a quibble with this (and it's not
>just limited to Oracle). Since a primary key must be unique,
>how else would you want to enforce its uniqueness?
>
You might want to give properties (other than default) to the index, our
you
might want to set the order of some columns to descending.
Now you have to first drop the system generated index and then create a new one.
regards,
Lauri Pietarinen
Received on Mon Nov 25 2002 - 19:20:16 CET