Firebird 2.5 Language Reference → Firebird 2.5 Language Reference → System 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 |
Firebird 2.5 Language Reference → Firebird 2.5 Language Reference → System Tables → RDB$VIEW_RELATIONS |