The Firebird 5.0 Language Reference

Reserved Words and KeywordsMonitoring Tables

`RDB$USER_PRIVILEGES`

RDB$USER_PRIVILEGES stores the SQL access privileges for Firebird users and privileged objects.

Column Name Data Type Description

Column Name	Data Type	Description
`RDB$USER`	`CHAR(63)`	The user or object that is granted this privilege
`RDB$GRANTOR`	`CHAR(63)`	The user who grants the privilege
`RDB$PRIVILEGE`	`CHAR(6)`	The privilege granted hereby: `A` - all (all privileges) `S` - select (selecting data) `I` - insert (inserting rows) `D` - delete (deleting rows) `R` - references (foreign key) `U` - update (updating data) `X` - executing (procedure) `G` - usage (of other object types) `M` - role membership `C` - DDL privilege create `L` - DDL privilege alter `O` - DDL privilege drop
`RDB$GRANT_OPTION`	`SMALLINT`	Whether the WITH GRANT OPTION authority is included with the privilege: `0` - not included `1` - included
`RDB$RELATION_NAME`	`CHAR(63)`	The name of the object (table, view, procedure or role) the privilege is granted ON
`RDB$FIELD_NAME`	`CHAR(63)`	The name of the column the privilege is applicable to, for a column-level privilege (an `UPDATE` or `REFERENCES` privilege)
`RDB$USER_TYPE`	`SMALLINT`	Identifies the type of user the privilege is granted TO (a user, a procedure, a view, etc.)
`RDB$OBJECT_TYPE`	`SMALLINT`	Identifies the type of the object the privilege is granted ON `0` - table `1` - view `2` - trigger `5` - procedure `7` - exception `8` - user `9` - domain `11` - character set `13` - role `14` - generator (sequence) `15` - function `16` - BLOB filter `17` - collation `18` - package

RDB$USER

CHAR(63)

The user or object that is granted this privilege

RDB$GRANTOR

CHAR(63)

The user who grants the privilege

RDB$PRIVILEGE

CHAR(6)

The privilege granted hereby:

A - all (all privileges)
S - select (selecting data)
I - insert (inserting rows)
D - delete (deleting rows)
R - references (foreign key)
U - update (updating data)
X - executing (procedure)
G - usage (of other object types)
M - role membership
C - DDL privilege create
L - DDL privilege alter
O - DDL privilege drop

RDB$GRANT_OPTION

SMALLINT

Whether the WITH GRANT OPTION authority is included with the privilege:

0 - not included
1 - included

RDB$RELATION_NAME

CHAR(63)

The name of the object (table, view, procedure or role) the privilege is granted ON

RDB$FIELD_NAME

CHAR(63)

The name of the column the privilege is applicable to, for a column-level privilege (an UPDATE or REFERENCES privilege)

RDB$USER_TYPE

SMALLINT

Identifies the type of user the privilege is granted TO (a user, a procedure, a view, etc.)

RDB$OBJECT_TYPE

SMALLINT

Identifies the type of the object the privilege is granted ON

0 - table
1 - view
2 - trigger
5 - procedure
7 - exception
8 - user
9 - domain
11 - character set
13 - role
14 - generator (sequence)
15 - function
16 - BLOB filter
17 - collation
18 - package

`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

`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.

`RDB$DATABASE`

RDB$DATABASE stores basic information about the database.It contains only one record.

Column Name Data Type Description

Column Name	Data Type	Description
`RDB$DESCRIPTION`	`BLOB TEXT`	Database comment text
`RDB$RELATION_ID`	`SMALLINT`	A number that steps up by one each time a table or view is added to the database
`RDB$SECURITY_CLASS`	`CHAR(63)`	The security class defined in `RDB$SECURITY_CLASSES` to apply access control limits common to the entire database
`RDB$CHARACTER_SET_NAME`	`CHAR(63)`	The name of the default character set for the database set in the `DEFAULT CHARACTER SET` clause when the database is created.`NULL` for character set `NONE`.
`RDB$LINGER`	`INTEGER`	Number of seconds "delay" (established with the `ALTER DATABASE SET LINGER` statement) until the database file is closed after the last connection to this database is closed (in SuperServer).`NULL` if no delay is set.
`RDB$SQL_SECURITY`	`BOOLEAN`	The default `SQL SECURITY` mode (`DEFINER` or `INVOKER`) applied to newly created objects: `NULL` - initial default (`INVOKER`) `FALSE` - `INVOKER` `TRUE` - `DEFINER`

RDB$DESCRIPTION

BLOB TEXT

Database comment text

RDB$RELATION_ID

SMALLINT

A number that steps up by one each time a table or view is added to the database

RDB$SECURITY_CLASS

CHAR(63)

The security class defined in RDB$SECURITY_CLASSES to apply access control limits common to the entire database

RDB$CHARACTER_SET_NAME

CHAR(63)

The name of the default character set for the database set in the DEFAULT CHARACTER SET clause when the database is created.NULL for character set NONE.

RDB$LINGER

INTEGER

Number of seconds "delay" (established with the ALTER DATABASE SET LINGER statement) until the database file is closed after the last connection to this database is closed (in SuperServer).NULL if no delay is set.

RDB$SQL_SECURITY

BOOLEAN

The default SQL SECURITY mode (DEFINER or INVOKER) applied to newly created objects:

NULL - initial default (INVOKER)
FALSE - INVOKER
TRUE - DEFINER

`RDB$DB_CREATORS`

RDB$DB_CREATORS contains a list of users granted the CREATE DATABASE privilege when using the specified database as a security database.

Column Name Data Type Description

Column Name	Data Type	Description
`RDB$USER`	`CHAR(63)`	User or role name
`RDB$USER_TYPE`	`SMALLINT`	Type of user `8` - user `13` - role

RDB$USER

CHAR(63)

User or role name

RDB$USER_TYPE

SMALLINT

Type of user

8 - user
13 - role

`RDB$DEPENDENCIES`

RDB$DEPENDENCIES stores the dependencies between database objects.

Column Name Data Type Description

Column Name	Data Type	Description
`RDB$DEPENDENT_NAME`	`CHAR(63)`	The name of the view, procedure, trigger, `CHECK` constraint or computed column the dependency is defined for, i.e., the dependent object
`RDB$DEPENDED_ON_NAME`	`CHAR(63)`	The name of the object that the defined object — the table, view, procedure, trigger, `CHECK` constraint or computed column — depends on
`RDB$FIELD_NAME`	`CHAR(63)`	The column name in the depended-on object that is referred to by the dependent view, procedure, trigger, `CHECK` constraint or computed column
`RDB$DEPENDENT_TYPE`	`SMALLINT`	Identifies the type of the dependent object: `0` - table `1` - view `2` - trigger `3` - computed column `4` - `CHECK` constraint `5` - procedure `6` - index expression `7` - exception `8` - user `9` - column `10` - index `15` - stored function `18` - package header `19` - package body
`RDB$DEPENDED_ON_TYPE`	`SMALLINT`	Identifies the type of the object depended on: `0` - table (or a column in it) `1` - view `2` - trigger `3` - computed column `4` - `CHECK` constraint `5` - procedure (or its parameter(s)) `6` - index expression `7` - exception `8` - user `9` - column `10` - index `14` - generator (sequence) `15` - UDF or stored function `17` - collation`18` - package header `19` - package body
`RDB$PACKAGE_NAME`	`CHAR(63)`	The package of a procedure or function for which this describes the dependency.

RDB$DEPENDENT_NAME

CHAR(63)

The name of the view, procedure, trigger, CHECK constraint or computed column the dependency is defined for, i.e., the dependent object

RDB$DEPENDED_ON_NAME

CHAR(63)

The name of the object that the defined object — the table, view, procedure, trigger, CHECK constraint or computed column — depends on

RDB$FIELD_NAME

CHAR(63)

The column name in the depended-on object that is referred to by the dependent view, procedure, trigger, CHECK constraint or computed column

RDB$DEPENDENT_TYPE

SMALLINT

Identifies the type of the dependent object:

0 - table
1 - view
2 - trigger
3 - computed column
4 - CHECK constraint
5 - procedure
6 - index expression
7 - exception
8 - user
9 - column
10 - index
15 - stored function
18 - package header
19 - package body

RDB$DEPENDED_ON_TYPE

SMALLINT

Identifies the type of the object depended on:

0 - table (or a column in it)
1 - view
2 - trigger
3 - computed column
4 - CHECK constraint
5 - procedure (or its parameter(s))
6 - index expression
7 - exception
8 - user
9 - column
10 - index
14 - generator (sequence)
15 - UDF or stored function
17 - collation18 - package header
19 - package body

RDB$PACKAGE_NAME

CHAR(63)

The package of a procedure or function for which this describes the dependency.