Icon Views Table

Structure
CREATE TABLE "Views"
(
"Name" VARCHAR(40) COLLATE "ANSI_CI",
"Description" CLOB COLLATE "ANSI",
"Attributes" CLOB COLLATE "ANSI",
"Version" DECIMAL(19,2),
"Definition" CLOB COLLATE "ANSI",
"Updateable" BOOLEAN,
"WithCheck" BOOLEAN,
"CreateSQL" CLOB COLLATE "ANSI_CI",
"DropSQL" CLOB COLLATE "ANSI_CI"
)

CREATE INDEX "Name" ON "Views"
("Name")

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

Related DDL Statements
StatementDescription
CREATE VIEWCreates a new view
ALTER VIEWAlters an existing view
DROP VIEWDrops an existing view
RENAME VIEWRenames an existing view
Image