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:


Related DDL Statements

---