RDB$PROCEDURES

Go Up to System Tables

RDB$PROCEDURES stores information about a database’s stored procedures.

RDB$PROCEDURES

Column name	Datatype	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: User-defined (value of 0) System-defined (value greater than 0)