"Antonio Natividad" <locosoft_lnx@...> wrote in message
news:20011214185320.85061.qmail@......

>
> 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
> - STORE RDB$RELATION_FIELDS failed
> - 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;
SQL>

I don't see any error.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing