> The RDB$DEPENDENCIES for that field is:
>
> SQL> select * from rdb$dependencies where
> rdb$field_name='NBR_OCCUR_RESERVA';
>
> RDB$DEPENDENT_NAME RDB$DEPENDED_ON_NAME
> RDB$FIELD_NAME RDB$DEPENDENT_TYPE
> RDB$DEPENDED_ON_TYPE
> =============================== ===============================
> =============================== ==================
> ====================
>
> DB$115 RESERVA
> NBR_OCCUR_RESERVA
> 2 0
> DB$115 RESERVA
> NBR_OCCUR_RESERVA
> 2 0
>
>
> I don't know what is that dependent_name 'DB$115'. Can anyone tell
> me ?

An error.

You can safely delete those two records and drop your field.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com