D.40 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(63) View name
RDB$RELATION_NAME CHAR(63) The name of the table, view or stored procedure 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
RDB$CONTEXT_TYPE SMALLINT Context type: 0 - table 1 - view 2 - stored procedure
RDB$PACKAGE_NAME CHAR(63) Package name for a stored procedure in a package