RDB$LOG_FILES
RDB$LOG_FILES
is not currently used.
RDB$LOG_FILES
RDB$LOG_FILES
is not currently used.
RDB$PACKAGES
RDB$PACKAGES
stores the definition (header and body) of SQL packages.
Column Name | Data Type | Description |
---|---|---|
|
|
Name of the package |
|
|
The PSQL sourcecode of the package header |
|
|
The PSQL sourcecode of the package body |
|
|
Indicates whether the body of the package is still valid. |
|
|
May reference a security class defined in the table |
|
|
The username of the user who created the package originally |
|
|
Flag:
|
|
|
Optional description of the package (comment) |
|
|
The
|
RDB$PAGES
RDB$PAGES
stores and maintains information about database pages and their usage.
Column Name | Data Type | Description |
---|---|---|
|
|
The unique number of a physically created database page |
|
|
The identifier of the table to which the page is allocated |
|
|
The number of the page in the sequence of all pages allocated to this table |
|
|
Indicates the page type (data, index, |
RDB$PROCEDURES
RDB$PROCEDURES
stores the definitions of stored procedures, including their PSQL source code and its binary language representation (BLR).The next table, RDB$PROCEDURE_PARAMETERS
, stores the definitions of input and output parameters.
Column Name | Data Type | Description |
---|---|---|
|
|
Stored procedure name (identifier) |
|
|
The procedure’s unique, system-generated identifier |
|
|
Indicates the number of input parameters. |
|
|
Indicates the number of output parameters. |
|
|
Any text comments related to the procedure |
|
|
The PSQL source code of the procedure |
|
|
The binary language representation (BLR) of the procedure code (PSQL procedures only) |
|
|
May point to the security class defined in the system table |
|
|
The username of the procedure’s Owner — the user who was |
|
|
A metadata description of the procedure, used internally for optimization |
|
|
Indicates whether the procedure is defined by a user (value 0) or by the system (a value of 1 or greater) |
|
|
Procedure type:
* for procedures created before Firebird 1.5 |
|
|
Indicates whether the source PSQL of the stored procedure remains valid after the latest |
|
|
Contains debugging information about variables used in the stored procedure |
|
|
Engine for external functions. |
|
|
The exported name of the external function in the procedure library.Note, this is often not the same as |
|
|
Package name of the procedure (or |
|
|
|
|
|
The
|