I have a lookup table which should have the primary key only.

I have created a 2nd index by mistake and want to delete it.

When I write

drop index TB_MEZ_CODMEZ, I get the error message

"statement failed, sql error code -607"

with the further explanation:

"unsuccessful metadata update: object index is in use"

This is weird, as nobody is using the index.

From IB_SQL, in the page Depend, I can see the following:

Dependent Name Field Name Dependent Type Depended on Type
Check_57 COD_MEZ 2 0
Check_57 2 0
Check_58 COD_MEZ 2 0
Check_58 2 0


What does it mean ?

Thank you

Duilio Foschi