RDB$VIEW_RELATIONS

Reserved Words and KeywordsMonitoring 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

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

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

`RDB$COLLATIONS`

RDB$COLLATIONS stores collations for all character sets.

Column Name Data Type Description

Column Name	Data Type	Description
`RDB$COLLATION_NAME`	`CHAR(63)`	Collation name
`RDB$COLLATION_ID`	`SMALLINT`	Collation identifier.Together with the character set identifier, it is a unique collation identifier
`RDB$CHARACTER_SET_ID`	`SMALLINT`	Character set identifier.Together with the collection sequence identifier, it is a unique identifier
`RDB$COLLATION_ATTRIBUTES`	`SMALLINT`	Collation attributes.It is a bit mask where the first bit shows whether trailing spaces should be taken into account in collations (0 - NO PAD; 1 - PAD SPACE);the second bit shows whether the collation is case-sensitive (0 - CASE SENSITIVE, 1 - CASE INSENSITIVE);the third bit shows whether the collation is accent-sensitive (0 - ACCENT SENSITIVE, 1 - ACCENT SENSITIVE).Thus, the value of 5 means that the collation does not take into account trailing spaces and is accent-insensitive
`RDB$SYSTEM_FLAG`	`SMALLINT`	Flag: the value of 0 means it is user-defined;the value of 1 means it is system-defined
`RDB$DESCRIPTION`	`BLOB TEXT`	Could store text description of the collation
`RDB$FUNCTION_NAME`	`CHAR(63)`	Not currently used
`RDB$BASE_COLLATION_NAME`	`CHAR(63)`	The name of the base collation for this collation
`RDB$SPECIFIC_ATTRIBUTES`	`BLOB TEXT`	Describes specific attributes
`RDB$SECURITY_CLASS`	`CHAR(63)`	May reference a security class defined in the table `RDB$SECURITY_CLASSES`, to apply access control limits to all users of this collation
`RDB$OWNER_NAME`	`CHAR(63)`	The username of the user who created the collation originally

RDB$COLLATION_NAME

CHAR(63)

Collation name

RDB$COLLATION_ID

SMALLINT

Collation identifier.Together with the character set identifier, it is a unique collation identifier

RDB$CHARACTER_SET_ID

SMALLINT

Character set identifier.Together with the collection sequence identifier, it is a unique identifier

RDB$COLLATION_ATTRIBUTES

SMALLINT

Collation attributes.It is a bit mask where the first bit shows whether trailing spaces should be taken into account in collations (0 - NO PAD; 1 - PAD SPACE);the second bit shows whether the collation is case-sensitive (0 - CASE SENSITIVE, 1 - CASE INSENSITIVE);the third bit shows whether the collation is accent-sensitive (0 - ACCENT SENSITIVE, 1 - ACCENT SENSITIVE).Thus, the value of 5 means that the collation does not take into account trailing spaces and is accent-insensitive

RDB$SYSTEM_FLAG

SMALLINT

Flag: the value of 0 means it is user-defined;the value of 1 means it is system-defined

RDB$DESCRIPTION

BLOB TEXT

Could store text description of the collation

RDB$FUNCTION_NAME

CHAR(63)

Not currently used

RDB$BASE_COLLATION_NAME

CHAR(63)

The name of the base collation for this collation

RDB$SPECIFIC_ATTRIBUTES

BLOB TEXT

Describes specific attributes

RDB$SECURITY_CLASS

CHAR(63)

May reference a security class defined in the table RDB$SECURITY_CLASSES, to apply access control limits to all users of this collation

RDB$OWNER_NAME

CHAR(63)

The username of the user who created the collation originally