Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Posts
    492

    Unanswered: Unable to drop an index

    According to sysindexes, I have a table with a primary key and an index. I'd like to drop the index. However, when I give the drop command, the message "Cannot drop the index 'eventlog._INDEX', because it does not exist in the system catalog." is returned.

    I'm not sure what to look for. How do I remove the index?

  2. #2
    Join Date
    Jan 2006
    Posts
    10
    You have a single index and want to remove it? If it is so, you won't be able to do this because PRIMARY KEY itself also is an unique index, so you will have to delete both of them just by removing key.

  3. #3
    Join Date
    Feb 2004
    Posts
    492
    No, I have a primary key which is a clustered index, and a regular index. I'd like to drop the index.

  4. #4
    Join Date
    Jan 2006
    Posts
    10
    Can you show the line from sysindexes which states about this second index?
    LongByte [delta]studio rockz
    Life is a short way from /dev/zero to /dev/null.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •