Subject Re: [ib-support] Alter table error
Author Claudio Valderrama C.
"Antonio Natividad" <locosoft_lnx@...> wrote in message
> First My table had a field named Campo1 and it had an
> Unique Constraint, then I dropped it and the field too
> but when I'm trying to create the field(alter table
> sentence) Campo1 again IB return an error like this:
> ---------------------------------------------------
> Statement failed, SQLCODE = -607
> Unsuccesful metadata update
> - attemp to store duplicate value (visible to active
> transactions) in unique index "RDB$INDEX_15"
> ---------------------------------------------------

Is this your case?

SQL> create table t(a int, b int not null unique);
SQL> alter table t drop b;
SQL> alter table t add b int not null unique;

I don't see any error.

Claudio Valderrama C. - -
Independent developer
Owner of the Interbase® WebRing