RDB$COLLATIONS

Reserved Words and KeywordsMonitoring Tables

`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

`RDB$CONFIG`

RDB$CONFIG is a virtual table showing the configuration settings of the current database for the current connection.

Table RDB$CONFIG is populated from in-memory structures upon request and its instance is preserved for the SQL query lifetime.For security reasons, access to this table is allowed for administrators only.Non-privileged users see no rows in this table (and no error is raised).

Column Name Data Type Description

Column Name	Data Type	Description
`RDB$CONFIG_ID`	`INTEGER`	Unique row identifier, no special meaning
`RDB$CONFIG_NAME`	`VARCHAR(63)`	Setting name (e.g. `TempCacheLimit`)
`RDB$CONFIG_VALUE`	`VARCHAR(255)`	Actual value of setting
`RDB$CONFIG_DEFAULT`	`VARCHAR(255)`	Default value of setting (defined in the Firebird code)
`RDB$CONFIG_IS_SET`	`BOOLEAN`	TRUE if value is explicitly configured, FALSE when default
`RDB$CONFIG_SOURCE`	`VARCHAR(255)`	Name of the configuration file (relative to the Firebird root directory) where this setting was taken from, or special value `DPB` if the setting was specified by the client application via API.

RDB$CONFIG_ID

INTEGER

Unique row identifier, no special meaning

RDB$CONFIG_NAME

VARCHAR(63)

Setting name (e.g. TempCacheLimit)

RDB$CONFIG_VALUE

VARCHAR(255)

Actual value of setting

RDB$CONFIG_DEFAULT

VARCHAR(255)

Default value of setting (defined in the Firebird code)

RDB$CONFIG_IS_SET

BOOLEAN

TRUE if value is explicitly configured, FALSE when default

RDB$CONFIG_SOURCE

VARCHAR(255)

Name of the configuration file (relative to the Firebird root directory) where this setting was taken from, or special value DPB if the setting was specified by the client application via API.