Subject Re: object index is in use
Author csswa
Ah yes, sorry. Late here (12.30 am). But he did say: "I want to
drop the primary index of a table, whose name is integ_366."

Regards
Andrew Ferguson
-- Luke...Jar Jar is your father.



--- In ib-support@y..., "Martijn Tonies" <m.tonies@u...> wrote:
> 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."
> >
> > :-(
> >