Hello,

I have a problem with dropping an index.
After running
ALTER TABLE VEHICLES DROP CONSTRAINT VEHICLES_IDX6;
I get
CONSTRAINT VEHICLES_IDX6 does not exist.

But when running
SELECT * FROM RDB$INDICES WHERE RDB$INDEX_NAME = 'VEHICLES_IDX6'
I can see IT IS THERE :)

The index was created on 2 fields of type date and timestamp
CREATE INDEX VEHICLES_IDX6 ON VEHICLES (INVOICE_DATE,INSERT_TIMESTAMP);

What could be the course of such database behaviour ? (Firebird 2.1.3)





[Non-text portions of this message have been removed]