deschenes_jacques wrote:

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

Just to avoid the wraparound problem, try

SQL> set list;
SQL> select * from rdb$dependencies where
CON> rdb$field_name='NBR_OCCUR_RESERVA';

You'll probably find that the DB$115 is actually RDB$115, which is a
system generated domain name. This query will give you the column and
table names.

SQL> select rdb$field_name, rdb$relation_name from rdb$relation_fields
CON> where rdb$field_source = 'RDB$115';


Good luck,


Ann