D.36. 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 NameData TypeDescription

RDB$VIEW_NAME

CHAR(31)

View name

RDB$RELATION_NAME

CHAR(31)

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(31)

Package name for a stored procedure in a package