The RDB$RELATIONS system table names all the tables and views
within the database. There is one row for each table or view.
The following table provides information on the columns of the
RDB$RELATIONS system table.
Data
Column Name Type Summary Description
RDB$RELATION_NAME char(31) The name of a table within
the database. Each row
within RBB$RELATIONS must
have a unique RDB$RELATION_
NAME.
RDB$RELATION_ID integer An identification number
used within the BLR to
identify a table.
RDB$STORAGE_ID integer A pointer to the database
logical area where the data
for this table is stored.
RDB$SYSTEM_FLAG integer A value that indicates
whether a table is a system
table or a user-defined
table:
o 0
If a user table.
o 1
If a system table.
RDB$DBKEY_LENGTH integer The length in bytes of the
database key. A database
key for a row in a table
is 8 bytes, and "n times
8 " for a view row, where
"n" is the number of tables
referred to in the view.
If the view does not
contain a dbkey, RDB$DBKEY_
LENGTH is 0. This occurs
when the view uses GROUP
BY, UNION, or returns a
statistical value.
RDB$MAX_VERSION integer The number of the current
version of the table
definition.
This value is matched with
the
RDB$VERSION column in
RDB$FIELD_VERSIONS to
determine the current row
format for the table.
RDB$CARDINALITY bigint The number of rows in the
table (cardinality).
RDB$FLAGS integer Flags.
RDB$VIEW_BLR list The BLR that describes the
of byte row selection expression
varying used to select the rows for
the view. If the table is
not a view, RDB$VIEW_BLR is
missing.
RDB$DESCRIPTION list A user-supplied description
of byte of this table or view.
varying
RDB$VIEW_SOURCE list The user's source text for
of byte the view definition.
varying
RDB$ACCESS_CONTROL list The access control policy
of byte for the table.
varying
RDB$EXTENSION_PARAMETERS list Reserved for future use.
of byte
varying
RDB$CDD_NAME list The fully qualified name of
of byte the dictionary entity upon
varying which the table definition
is based, as specified
in the SQL clause, FROM
PATHNAME.
RDBVMS$SECURITY_AUDIT integer A bit mask that indicates
the privileges that will
be audited for the table,
as specified in the RMU Set
Audit command.
RDBVMS$SECURITY_ALARM integer A bit mask that indicates
the privileges that produce
alarms for the table, as
specified in the RMU Set
Audit command.
RDB$SECURITY_CLASS char(20) Reserved for future use.
RDBVMS$SECURITY_AUDIT2 integer Reserved for future use.
RDBVMS$SECURITY_ALARM2 integer Reserved for future use.
RDB$CREATED date vms Set when the table or view
is created (for system
tables it will be the same
as the database creation
timestamp).
RDB$LAST_ALTERED date vms Set when SQL ALTER TABLE,
CREATE/ALTER STORAGE MAP,
ALTER DOMAIN, GRANT, or
REVOKE statements cause
changes to this system
table.
RDB$RELATION_CREATOR char(31) Creator of this system
table.
RDB$ROW_CLUSTER_FACTOR bigint(7) The ratio of the number of
clump changes that occur
when you sequentially read
the rows to the number of
rows in a table. If a row
is fragmented and part of
its fragment is located in
a clump different than the
current one or immediate
next one then it should be
counted as a clump change.
RDB$TYPE_ID integer Reserved for future use.
1 – RDB$FLAGS
Represents flags for RDB$RELATIONS system table.
Bit
Position Description
0 This table is a view.
1 This table is not compressed.
2 The SQL clause, WITH CHECK OPTION, is used in this view
definition.
3 Indicates a special internal system table.
4 This view is not an ANSI updatable view.
5 Reserved for future use.
6 Reserved for future use.
7 Reserved for future use.
8 Ignore Bit 1 and use RDB$STORAGE_MAPS for compression
information.
9 Set for temporary table.
10 Set for global temporary table; clear for local
temporary table.
11 Set for delete data on commit; clear for preserve data
on commit.
12 Reserved for future use.
13 Set if view or table references a local temporary
table.
14 Special read-only information table.
15 System table has storage map.
16 View references only temporary table.