Icon Functions Table

Structure
CREATE TABLE "Functions"
(
"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,
"Type" VARCHAR(30) COLLATE "ANSI_CI",
"Collation" VARCHAR(40) COLLATE "ANSI_CI",
"Length" INTEGER,
"Precision" INTEGER,
"Scale" INTEGER,
"CreateSQL" CLOB COLLATE "ANSI_CI",
"DropSQL" CLOB COLLATE "ANSI_CI"
)

CREATE INDEX "Name" ON "Functions"
("Name")

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

The Implementation column values are as follows:

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

Related DDL Statements
StatementDescription
CREATE FUNCTIONCreates a new function
ALTER FUNCTIONAlters an existing function
DROP FUNCTIONDrops an existing function
RENAME FUNCTIONRenames an existing function
Image