Icon ProcedureParams Table

Structure
CREATE TABLE "ProcedureParams"
(
"ProcedureName" VARCHAR(40) COLLATE "ANSI_CI",
"Name" VARCHAR(40) COLLATE "ANSI_CI",
"Description" CLOB COLLATE "ANSI",
"Mode" VARCHAR(15) COLLATE "ANSI_CI",
"Type" VARCHAR(30) COLLATE "ANSI_CI",
"Collation" VARCHAR(40) COLLATE "ANSI_CI",
"Length" INTEGER,
"Precision" INTEGER,
"Scale" INTEGER,
"OrdinalPos" INTEGER
)

CREATE INDEX "ProcedureName" ON "ProcedureParams"
("ProcedureName")

CREATE INDEX "Name" ON "ProcedureParams"
("Name")

Description
This table contains the defined parameters for the procedures in an ElevateDB database.

The Mode column values are as follows:

ModeDescription
UnknownThe parameter type is unknown
InThe parameter is an input parameter
OutThe parameter is an output parameter
InOutThe parameter is both an input and output parameter

Related DDL Statements
StatementDescription
CREATE PROCEDURECreates a new procedure
Image