Firebird Documentation IndexFirebird 2.5 Language ReferenceSystem Tables → RDB$VIEW_RELATIONS
Firebird Home Firebird Home Prev: RDB$USER_PRIVILEGESFirebird Documentation IndexUp: 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 Documentation IndexUp: System TablesNext: Monitoring Tables
Firebird Documentation IndexFirebird 2.5 Language ReferenceSystem Tables → RDB$VIEW_RELATIONS