| RDB$PARAMETER_NAME |
CHAR(31) |
Parameter name |
| RDB$PROCEDURE_NAME |
CHAR(31) |
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(31) |
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 default value for the parameter, in the binary language representation (BLR) |
| RDB$DEFAULT_SOURCE |
BLOB TEXT |
The default value for the parameter, in PSQL code |
| RDB$COLLATION_ID |
SMALLINT |
The identifier of the collation sequence 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(31) |
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(31) |
The name of the table the parameter references, if it was
declared using TYPE OF COLUMN instead of a regular data type
|
