Structure

---

CREATE TABLE "ViewColumns"
(
"ViewName" VARCHAR(40) COLLATE "ANSI_CI",
"Name" VARCHAR(40) COLLATE "ANSI_CI",
"Origin" VARCHAR(90) COLLATE "ANSI_CI",
"Type" VARCHAR(30) COLLATE "ANSI_CI",
"Collation" VARCHAR(40) COLLATE "ANSI_CI",
"Length" INTEGER,
"Precision" INTEGER,
"Scale" INTEGER,
"OrdinalPos" INTEGER,
"CreateSQL" CLOB COLLATE "ANSI_CI",
"DropSQL" CLOB COLLATE "ANSI_CI"
)

CREATE INDEX "ViewName" ON "ViewColumns"
("ViewName")

CREATE INDEX "Name" ON "ViewColumns"
("Name")

Description

---

This table contains the defined columns for the views in an ElevateDB database.

Related DDL Statements

---