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)

You created an index and not a table constraint. Execute:

DROP INDEX VEHICLES_IDX6;


And don't forget a commit. ;-)



--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!