Re: How to disable index?

To disable an existing integrity constraint, use

alter table disable constraint_name;

To enable a constraint, use

enable constraint_name;

see the documentation for details.

Gennady schrieb:

> Hello,
> Is it possible to DISABLE and then ENABLE multicolumn index ( without DROP
> and CREATE index)?
>
> Thanks,
> Gennady
Received on Mon Nov 15 1999 - 00:51:56 CST