He wrote: DROP CONSTRAINT

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> >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."
>
> :-(
>