Unable to drop index

18 Aug 2006 2:40 PM

StrykerSoccer

I am trying to drop an index. The error I'm getting is: Cannot drop
the index 'dbname.PK_sku_price', because it does not exist in the
system catalog.

Thanks...Nali

18 Aug 2006 3:27 PM

Roy Harvey

To drop an index you have to use the table (or view) name, not the
dbname, as the qualifier. Do you really have a table named dbname?

Roy Harvey
Beacon Falls, CT

On 18 Aug 2006 07:40:08 -0700, StrykerSoc***@gmail.com wrote:

Show quote

>I am trying to drop an index. The error I'm getting is: Cannot drop
>the index 'dbname.PK_sku_price', because it does not exist in the
>system catalog.
>
>Thanks...Nali

18 Aug 2006 3:56 PM

amish

Roy Harvey wrote:

> To drop an index you have to use the table (or view) name, not the
> dbname, as the qualifier. Do you really have a table named dbname?
>
> Roy Harvey
> Beacon Falls, CT
>
> On 18 Aug 2006 07:40:08 -0700, StrykerSoc***@gmail.com wrote:
>
> >I am trying to drop an index. The error I'm getting is: Cannot drop
> >the index 'dbname.PK_sku_price', because it does not exist in the
> >system catalog.
> >
> >Thanks...Nali

Try
Drop index <table name>.<index name>

Regards
Amish Shah
http://shahamishm.tripod.com

18 Aug 2006 6:13 PM

Scott Morris

<StrykerSoc***@gmail.com> wrote in message

news:1155912008.673020.11910@m79g2000cwm.googlegroups.com...
>I am trying to drop an index. The error I'm getting is: Cannot drop
> the index 'dbname.PK_sku_price', because it does not exist in the
> system catalog.

Based on the name alone, it looks like you are using the name of a primary
key constraint. If so, you remove it using "alter table".