D.29 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(63) Table or view name
RDB$SECURITY_CLASS CHAR(63) 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(63) The user name of the user who created the table or view originally
RDB$DEFAULT_CLASS CHAR(63) 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)
RDB$SQL_SECURITY BOOLEAN The SQL SECURITY mode (DEFINER or INVOKER): NULL - initial default (INVOKER) FALSE - INVOKER TRUE - DEFINER