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?
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.