"Bob Murdoch" <mailgroups@...> wrote:

>
> What if the index is the primary key? Can I alter inactive/active?

-- to deactivate it
update rdb$indices
set rdb$index_inactive = 3
where rdb$index_name = ?

-- to reactivate back
update rdb$indices
set rdb$index_inactive = 0
where rdb$index_name = ?

Hovewer, I wouldn't promise this trick will work in future FB versions :-)


Dmitry