Structure

---

CREATE TABLE "ViewIndexes"
(
"ViewName" VARCHAR(40) COLLATE "ANSI_CI",
"Name" VARCHAR(40) COLLATE "ANSI_CI",
"Description" CLOB COLLATE "ANSI",
"Type" VARCHAR(15) COLLATE "ANSI_CI",
"CreateSQL" CLOB COLLATE "ANSI_CI",
"DropSQL" CLOB COLLATE "ANSI_CI"
)

CREATE INDEX "TableName" ON "Indexes"
("TableName")

CREATE INDEX "Name" ON "Indexes"
("Name")

Description

---

This table contains the defined indexes for the non-updateable views in an ElevateDB database.

The Type column values are as follows:


Related DDL Statements

---