Subject Alter table error
Author Antonio Natividad
Hello:

I have an error when I'm trying to create a field in a
table.

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"
---------------------------------------------------

What can I do to create my field and my constraint
again?

Regards

Antonio



_________________________________________________________
Do You Yahoo!?
Encuentra el coche de tus sueƱos en Yahoo! Autos http://autos.yahoo.com.mx