Subject | What are the RDB$XX values in RDB$FIELDS ??? |
---|---|
Author | Andrew Monteith |
Post date | 2003-08-18T09:25:45Z |
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
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