Icon Procedures Table

Structure
CREATE TABLE "Procedures"
(
"Name" VARCHAR(40) COLLATE "ANSI_CI",
"Description" CLOB COLLATE "ANSI",
"Attributes" CLOB COLLATE "ANSI",
"Version" DECIMAL(19,2),
"Implementation" VARCHAR(15) COLLATE "ANSI_CI",
"Definition" CLOB COLLATE "ANSI",
"ModuleName" VARCHAR(60) COLLATE "ANSI_CI",
"NumParams" INTEGER,
"CreateSQL" CLOB COLLATE "ANSI_CI",
"DropSQL" CLOB COLLATE "ANSI_CI"
)

CREATE INDEX "Name" ON "Procedures"
("Name")

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

The Implementation column values are as follows:

ImplementationDescription
SQLThe procedure is implemented in SQL
ExternalThe procedure is implemented in an external module

Related DDL Statements
StatementDescription
CREATE PROCEDURECreates a new procedure
ALTER PROCEDUREAlters an existing procedure
DROP PROCEDUREDrops an existing procedure
RENAME PROCEDURERenames an existing procedure
Image