RDB$VIEW RELATIONS

Go Up to System Tables

RDB$VIEW_RELATIONS is not used by SQL objects.

RDB$VIEW_RELATIONS

Column name	Data type 7	Length	Description
RDB$VIEW_NAME	CHAR	67	Name of a view: The combination of RDB$VIEW_NAME and RDB$VIEW_CONTEXT must be unique
RDB$RELATION_NAME	CHAR	67	Name of a table referenced in the view definition
RDB$VIEW_CONTEXT	SMALLINT		Alias used to qualify view columns; must have the same value as the alias used in the view BLR (Binary Language Representation) for this query
RDB$CONTEXT_NAME	CHAR	67	Textual version of the alias identified in RDB$VIEW_CONTEXT This variable must: Match the value of the RDB$VIEW_SOURCE column for the corresponding table in RDB$RELATIONS Be unique in the view