Firebird 2.5 Language ReferenceFirebird 2.5 Language ReferenceSystem Tables → RDB$RELATIONS
Firebird Firebird Prev: RDB$REF_CONSTRAINTSFirebird 2.5 Language ReferenceUp: System TablesNext: RDB$RELATION_CONSTRAINTS

RDB$RELATIONS

RDB$RELATIONS stores the top-level definitions and attributes of all tables and views in the system.

Column Name Data Type Description
RDB$VIEW_BLR BLOB BLR Stores the query specification for a view, in the binary language representation (BLR). The field stores NULL for a table
RDB$VIEW_SOURCE BLOB TEXT Contains the original source text of the query for a view, in SQL language. User comments are included. The field stores NULL for a table
RDB$DESCRIPTION BLOB TEXT Could store comments related to the table or view
RDB$RELATION_ID SMALLINT Internal identifier of the table or view
RDB$SYSTEM_FLAG SMALLINT indicates whether the table or view is user-defined (value 0) or system-defined (value 1 or greater)
RDB$DBKEY_LENGTH SMALLINT The total length of the database key. For a table: 8 bytes. For a view, the length is 8 multiplied by the number of tables referenced by the view
RDB$FORMAT SMALLINT Internal use, points to the relation's record in RDB$FORMATS—do not modify
RDB$FIELD_ID SMALLINT The field ID for the next column to be added. The number is not decremented when a column is dropped.
RDB$RELATION_NAME CHAR(31) Table or view name
RDB$SECURITY_CLASS CHAR(31) May reference a security class defined in the table RDB$SECURITY_CLASSES, in order to apply access control limits to all users of this table or view
RDB$EXTERNAL_FILE VARCHAR(255) The full path to the external data file if the table is defined with the EXTERNAL FILE clause
RDB$RUNTIME BLOB Table metadata description, used internally for optimization
RDB$EXTERNAL_DESCRIPTION BLOB Could store comments related to the external file of an external table
RDB$OWNER_NAME CHAR(31) The user name of the user who created the table or view originally
RDB$DEFAULT_CLASS CHAR(31) Default security class, used when a new column is added to the table
RDB$FLAGS SMALLINT Internal flags
RDB$RELATION_TYPE SMALLINT The type of the relation object being described:
0 - system or user-defined table
1 - view
2 - external table
3 - monitoring table
4 - connection-level GTT (PRESERVE ROWS)
5 - transaction-level GTT (DELETE ROWS)

Prev: RDB$REF_CONSTRAINTSFirebird 2.5 Language ReferenceUp: System TablesNext: RDB$RELATION_CONSTRAINTS
Firebird 2.5 Language ReferenceFirebird 2.5 Language ReferenceSystem Tables → RDB$RELATIONS