Yeeee! :) Thanx!




________________________________
From: Thomas Steinmaurer <ts@...>
To: firebird-support@yahoogroups.com
Sent: Mon, December 13, 2010 8:47:23 AM
Subject: Re: [firebird-support] Problem with dropping an index


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!






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