Can't do it, Duilio...

From langref manual:

"Description DROP INDEX removes a user-defined index from a database.
An index can be dropped by its creator, the SYSDBA user, or any user
with operating system root privileges.

IMPORTANT You cannot drop system-defined indexes, such as those for
UNIQUE, PRIMARY KEY, and FOREIGN KEY.

An index in use is not dropped until it is no longer in use."

:-(

Regards,
Andrew Ferguson
-- Like fuzzy logic, but without the logic.

--- In ib-support@y..., Duilio Foschi <dedalus@y...> wrote:
> I want to drop the primary index of a table, whose name is
integ_366.
>
> When I write
>
> alter table Tablename drop constraint integ_366
>
> I get the error message
>
> "index is in use".
>
> Surely I am the only user of the database.
>
> I even rebooted, but the problem stays there.
>
> I need to drop the @#$% index.
>
> Any help ?
>
> TIA
>
> Duilio Foschi