Subject What are the RDB$XX values in RDB$FIELDS ???
Author Andrew Monteith
Hi All

In an attempt to get rid of all the columns in our database without
domains attached, I ran this query.

select RDB$RELATION_NAME, RDB$FIELD_NAME, RDB$FIELD_SOURCE
from RDB$RELATION_FIELDS
where RDB$SYSTEM_FLAG = 0
and RDB$FIELD_SOURCE starts with 'RDB$'

I then altered all the columns to have domains, which resulted in
the above query returning an empty result set.

I then ran this query

select *
from RDB$FIELDS
where RDB$SYSTEM_FLAG = 0
and RDB$FIELD_NAME starts with 'RDB$'

and got 3447 rows as output.

Example output
RDB$FIELD_NAME
--------------
RDB$70
RDB$71
RDB$72
RDB$23
RDB$24
...

Can anyone please tell what these are used for ?

Regards
Andrew Monteith