Reserved Words and KeywordsMonitoring Tables

`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

docnext count = 1

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