Firebird 2.5 Language ReferenceFirebird 2.5 Language ReferenceSystem Tables → RDB$VIEW_RELATIONS
Firebird Firebird Prev: RDB$USER_PRIVILEGESFirebird 2.5 Language ReferenceUp: System TablesNext: Monitoring Tables

RDB$VIEW_RELATIONS

RDB$VIEW_RELATIONS stores the tables that are referred to in view definitions. There is one record for each table in a view.

Column Name Data Type Description
RDB$VIEW_NAME CHAR(31) View name
RDB$RELATION_NAME CHAR(31) The name of the table the view references
RDB$VIEW_CONTEXT SMALLINT The alias used to reference the view column in the BLR code of the query definition
RDB$CONTEXT_NAME CHAR(255) The text associated with the alias reported in the RDB$VIEW_CONTEXT column

Prev: RDB$USER_PRIVILEGESFirebird 2.5 Language ReferenceUp: System TablesNext: Monitoring Tables
Firebird 2.5 Language ReferenceFirebird 2.5 Language ReferenceSystem Tables → RDB$VIEW_RELATIONS