Re: FK Constraint on index not PK

Joshua D. Drake a écrit :
> On Fri, 2007-01-12 at 17:50 +0100, Stéphane Schildknecht wrote:
>
>> Dear community members,
>>
>> I'm having a quite strange behaviour while trying to drop some index.
>>
>> We have some tables with two indexes on a primary key. The first one was
>> automatically created by the primary constraint. The second one was
>> manually created on the same column. Don't know why, but I would now
>> want to suppress it.
>>
>
> Drop the second index. It is redundant.
>

I know it. But I can't.

SAS