The RDB$RELATION_FIELDS system table contains one row for each
column in each table. The following table provides information on
the columns of the RDB$RELATION_FIELDS system table.
Data
Column Name Type Summary Description
RDB$RELATION_NAME char(31) The name of the table
that contains the column
represented by this row.
RDB$FIELD_NAME char(31) The name of the column
represented by this row
within the table. Each
RDB$RELATION_FIELDS
row that has the same
RDB$RELATION_NAME must
have a unique RDB$FIELD_
NAME.
RDB$FIELD_SOURCE char(31) The name of the domain
(from the RDB$FIELD_NAME
column within the
RDB$FIELDS table) that
supplies the definition for
this column.
RDB$FIELD_ID integer An identifier that can
be used within the BLR to
name the column represented
by this row. Oracle Rdb
assigns each column an id
that is permanent for as
long as the column exists
within the table.
RDB$FIELD_POSITION integer The ordinal position of the
column represented by this
row, relative to the other
columns in the same table.
RDB$QUERY_NAME char(31) The query name of this
column. RDB$QUERY_NAME can
be null.
RDB$UPDATE_FLAG integer A value that indicates
whether a column can be
updated:
o 0
If column cannot be
updated.
o 1
If column can be
updated.
RDB$QUERY_HEADER list The query header of this
of byte column for use by SQL.
varying Column attributes in
RDB$RELATION_FIELDS take
precedence over RDB$FIELDS.
If the attribute value is
missing in
RDB$RELATION_FIELDS,
SQL uses the value from
RDB$FIELDS.
RDB$DESCRIPTION list A user-supplied description
of byte of the contents of this
varying row.
RDB$VIEW_CONTEXT integer For view tables, this
column identifies the
context variable used to
qualify the view column.
This context variable must
be defined within the row
selection expression that
defines the view. The
context variable appears
in the BLR represented by
the column RDB$VIEW_BLR in
RDB$RELATIONS.
RDB$BASE_FIELD char(31) The local name of the
column used as a component
of a view. The name is
qualified by the context
variable identified in
RDB$VIEW_CONTEXT.
RDB$DEFAULT_VALUE list The default value used by
of byte non-SQL interfaces when
varying no value is specified for
a column during a STORE
clause.
It differs from
RDB$MISSING_VALUE in that
it holds an actual column
value. Column attributes in
RDB$RELATION_FIELDS take
precedence over attributes
in RDB$FIELDS.
If the attribute value is
missing in
RDB$RELATION_FIELDS, the
value from RDB$FIELDS is
used.
RDB$EDIT_STRING varchar(25The edit string to be
used by interactive SQL
when printing the column.
RDB$EDIT_STRING can be
null.
RDB$EXTENSION_PARAMETERS list Reserved for future use.
of byte
varying
RDB$ACCESS_CONTROL list The access control list for
of byte the column.
varying
RDB$DEFAULT_VALUE2 list The BLR for SQL default
of byte value. This value is used
varying when no value is provided
in an SQL INSERT statement.
RDBVMS$SECURITY_AUDIT integer A bit mask that indicates
the privileges that will be
audited for the database,
as specified in the RMU Set
Audit command.
RDBVMS$SECURITY_ALARM integer A bit mask that indicates
the privileges that will
produce alarms for the
database, as specified in
the RMU Set Audit command.
RDB$SECURITY_CLASS char(20) Reserved for future use.