RDB$PACKAGES

Reserved Words and KeywordsMonitoring Tables

`RDB$PACKAGES`

RDB$PACKAGES stores the definition (header and body) of SQL packages.

Column Name Data Type Description

Column Name	Data Type	Description
`RDB$PACKAGE_NAME`	`CHAR(63)`	Name of the package
`RDB$PACKAGE_HEADER_SOURCE`	`BLOB TEXT`	The PSQL sourcecode of the package header
`RDB$PACKAGE_BODY_SOURCE`	`BLOB TEXT`	The PSQL sourcecode of the package body
`RDB$VALID_BODY_FLAG`	`SMALLINT`	Indicates whether the body of the package is still valid.`NULL` or `0` indicates the body is not valid.
`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 package
`RDB$OWNER_NAME`	`CHAR(63)`	The username of the user who created the package originally
`RDB$SYSTEM_FLAG`	`SMALLINT`	Flag: `0` - user-defined `1` or higher - system-defined
`RDB$DESCRIPTION`	`BLOB TEXT`	Optional description of the package (comment)
`RDB$SQL_SECURITY`	`BOOLEAN`	The `SQL SECURITY` mode (`DEFINER` or `INVOKER`): `NULL` - initial default (`INVOKER`) `FALSE` - `INVOKER` `TRUE` - `DEFINER`

RDB$PACKAGE_NAME

CHAR(63)

Name of the package

RDB$PACKAGE_HEADER_SOURCE

BLOB TEXT

The PSQL sourcecode of the package header

RDB$PACKAGE_BODY_SOURCE

BLOB TEXT

The PSQL sourcecode of the package body

RDB$VALID_BODY_FLAG

SMALLINT

Indicates whether the body of the package is still valid.NULL or 0 indicates the body is not valid.

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 package

RDB$OWNER_NAME

CHAR(63)

The username of the user who created the package originally

RDB$SYSTEM_FLAG

SMALLINT

Flag:

0 - user-defined
1 or higher - system-defined

RDB$DESCRIPTION

BLOB TEXT

Optional description of the package (comment)

RDB$SQL_SECURITY

BOOLEAN

The SQL SECURITY mode (DEFINER or INVOKER):

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

`RDB$PAGES`

RDB$PAGES stores and maintains information about database pages and their usage.

Column Name Data Type Description

Column Name	Data Type	Description
`RDB$PAGE_NUMBER`	`INTEGER`	The unique number of a physically created database page
`RDB$RELATION_ID`	`SMALLINT`	The identifier of the table to which the page is allocated
`RDB$PAGE_SEQUENCE`	`INTEGER`	The number of the page in the sequence of all pages allocated to this table
`RDB$PAGE_TYPE`	`SMALLINT`	Indicates the page type (data, index, `BLOB`, etc.).For system use

RDB$PAGE_NUMBER

INTEGER

The unique number of a physically created database page

RDB$RELATION_ID

SMALLINT

The identifier of the table to which the page is allocated

RDB$PAGE_SEQUENCE

INTEGER

The number of the page in the sequence of all pages allocated to this table

RDB$PAGE_TYPE

SMALLINT

Indicates the page type (data, index, BLOB, etc.).For system use