RDB$PROCEDURES
Go Up to System Tables
RDB$PROCEDURES stores information about a database’s stored procedures.
| Column name | Data type | Length | Description |
|---|---|---|---|
|
RDB$PROCEDURE_NAME |
CHAR |
67 |
Procedure name |
|
RDB$PROCEDURE_ID |
SMALLINT |
Procedure number | |
|
RDB$PROCEDURE_INPUTS |
SMALLINT |
Number of input parameters | |
|
RDB$PROCEDURE_ OUTPUTS |
SMALLINT |
Number of output parameters | |
|
RDB$DESCRIPTION |
BLOB |
Subtype Text: User-written description of the procedure | |
|
RDB$PROCEDURE_SOURCE |
BLOB |
Subtype Text: Source code for the procedure | |
|
RDB$PROCEDURE_BLR |
BLOB |
Subtype BLR: BLR (Binary Language Representation) of the procedure source | |
|
RDB$SECURITY_CLASS |
CHAR |
67 |
Security class of the procedure |
|
RDB$OWNER_NAME |
CHAR |
67 |
User who created the procedure (the owner for SQL security purposes) |
|
RDB$RUNTIME |
BLOB |
Subtype Summary: Describes procedure metadata; used for performance enhancement | |
|
RDB$SYSTEM_FLAG |
SMALLINT |
Indicates whether the procedure is:
|