RDB$PROCEDURE_PARAMETERS

Reserved Words and KeywordsMonitoring Tables

`RDB$PROCEDURE_PARAMETERS`

RDB$PROCEDURE_PARAMETERS stores the parameters of stored procedures and their attributes.It holds one row for each parameter.

Column Name Data Type Description

Column Name	Data Type	Description
`RDB$PARAMETER_NAME`	`CHAR(63)`	Parameter name
`RDB$PROCEDURE_NAME`	`CHAR(63)`	The name of the procedure where the parameter is defined
`RDB$PARAMETER_NUMBER`	`SMALLINT`	The sequential number of the parameter
`RDB$PARAMETER_TYPE`	`SMALLINT`	Indicates whether the parameter is for input (value 0) or output (value 1)
`RDB$FIELD_SOURCE`	`CHAR(63)`	The name of the user-created domain, when a domain is referenced instead of a data type.If the name starts with the prefix “RDB$”, it is the name of the domain automatically generated by the system for the parameter.
`RDB$DESCRIPTION`	`BLOB TEXT`	Could store comments related to the parameter
`RDB$SYSTEM_FLAG`	`SMALLINT`	Indicates whether the parameter was defined by the system (value or greater) or by a user (value 0)
`RDB$DEFAULT_VALUE`	`BLOB BLR`	The binary language representation (BLR) of the default value of the parameter
`RDB$DEFAULT_SOURCE`	`BLOB TEXT`	The default value for the parameter, in PSQL code
`RDB$COLLATION_ID`	`SMALLINT`	The identifier of the collation used for a character parameter
`RDB$NULL_FLAG`	`SMALLINT`	The flag indicating whether `NULL` is allowable
`RDB$PARAMETER_MECHANISM`	`SMALLINT`	Flag: indicates how this parameter is passed: `0` - by value `1` - by reference `2` - by descriptor `3` - by BLOB descriptor
`RDB$FIELD_NAME`	`CHAR(63)`	The name of the column the parameter references, if it was declared using `TYPE OF COLUMN` instead of a regular data type.Used in conjunction with `RDB$RELATION_NAME` (see next).
`RDB$RELATION_NAME`	`CHAR(63)`	The name of the table the parameter references, if it was declared using `TYPE OF COLUMN` instead of a regular data type
`RDB$PACKAGE_NAME`	`CHAR(63)`	Package name of the procedure (or `NULL` for a top-level stored procedure)

RDB$PARAMETER_NAME

CHAR(63)

Parameter name

RDB$PROCEDURE_NAME

CHAR(63)

The name of the procedure where the parameter is defined

RDB$PARAMETER_NUMBER

SMALLINT

The sequential number of the parameter

RDB$PARAMETER_TYPE

SMALLINT

Indicates whether the parameter is for input (value 0) or output (value 1)

RDB$FIELD_SOURCE

CHAR(63)

The name of the user-created domain, when a domain is referenced instead of a data type.If the name starts with the prefix “RDB$”, it is the name of the domain automatically generated by the system for the parameter.

RDB$DESCRIPTION

BLOB TEXT

Could store comments related to the parameter

RDB$SYSTEM_FLAG

SMALLINT

Indicates whether the parameter was defined by the system (value or greater) or by a user (value 0)

RDB$DEFAULT_VALUE

BLOB BLR

The binary language representation (BLR) of the default value of the parameter

RDB$DEFAULT_SOURCE

BLOB TEXT

The default value for the parameter, in PSQL code

RDB$COLLATION_ID

SMALLINT

The identifier of the collation used for a character parameter

RDB$NULL_FLAG

SMALLINT

The flag indicating whether NULL is allowable

RDB$PARAMETER_MECHANISM

SMALLINT

Flag: indicates how this parameter is passed:

0 - by value
1 - by reference
2 - by descriptor
3 - by BLOB descriptor

RDB$FIELD_NAME

CHAR(63)

The name of the column the parameter references, if it was declared using TYPE OF COLUMN instead of a regular data type.Used in conjunction with RDB$RELATION_NAME (see next).

RDB$RELATION_NAME

CHAR(63)

The name of the table the parameter references, if it was declared using TYPE OF COLUMN instead of a regular data type

RDB$PACKAGE_NAME

CHAR(63)

Package name of the procedure (or NULL for a top-level stored procedure)

`RDB$PUBLICATIONS`

RDB$PUBLICATIONS stores the replication publications defined in the database.

Column Name Data Type Description

Column Name	Data Type	Description
`RDB$PUBLICATION_NAME`	`CHAR(63)`	Publication name
`RDB$OWNER_NAME`	`CHAR(63)`	The username of the user who created the publication
`RDB$SYSTEM_FLAG`	`SMALLINT`	Flag: `0` - user-defined `1` or higher - system-defined
`RDB$ACTIVE_FLAG`	`SMALLINT`	Inactive (`0`) or active (`1`)
`RDB$AUTO_ENABLE`	`SMALLINT`	Automatically add new tables to publication: `0` - disabled `1` - enabled (tables are automatically added to this publication)

RDB$PUBLICATION_NAME

CHAR(63)

Publication name

RDB$OWNER_NAME

CHAR(63)

The username of the user who created the publication

RDB$SYSTEM_FLAG

SMALLINT

Flag:

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

RDB$ACTIVE_FLAG

SMALLINT

Inactive (0) or active (1)

RDB$AUTO_ENABLE

SMALLINT

Automatically add new tables to publication:

0 - disabled
1 - enabled (tables are automatically added to this publication)

Note	In Firebird 5.0 there is a single (pre-defined) publication named `RDB$DEFAULT`.User-defined publications will be available in future Firebird releases.