Structure

---

CREATE TABLE "IndexColumns"
(
"TableName" VARCHAR(40) COLLATE "ANSI_CI",
"IndexName" VARCHAR(40) COLLATE "ANSI_CI",
"ColumnName" VARCHAR(40) COLLATE "ANSI_CI",
"Descending" BOOLEAN,
"Collation" VARCHAR(40) COLLATE "ANSI_CI",
"OrdinalPos" INTEGER
)

CREATE INDEX "TableName" ON "IndexColumns"
("TableName")

CREATE INDEX "IndexName" ON "IndexColumns"
("IndexName")

CREATE INDEX "ColumnName" ON "IndexColumns"
("ColumnName")

Description

---

This table contains the columns that make up the defined indexes for the tables in an ElevateDB database.

Related DDL Statements

---