Indexes Table

Structure

CREATE TABLE "Indexes"
(
"TableName" VARCHAR(40) COLLATE "ANSI_CI",
"Name" VARCHAR(40) COLLATE "ANSI_CI",
"Description" CLOB COLLATE "ANSI",
"Type" VARCHAR(15) COLLATE "ANSI_CI",
"OwnerConstraint" VARCHAR(40) COLLATE "ANSI_CI",
"IndexedWordLength" INTEGER,
"FilterTypeColumn" VARCHAR(40) COLLATE "ANSI_CI",
"WordGenerator" VARCHAR(40) 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")

CREATE INDEX "Type" ON "Indexes"
("Type")

Description

This table contains the defined indexes for the tables in an ElevateDB database.

The Type column values are as follows:

Type	Description

Index	The index is a normal index
Primary Key	The index is used to enforce a primary key constraint, and is maintained automatically by ElevateDB
Foreign Key	The index is used to enforce a foreign key constraint, and is maintained automatically by ElevateDB
Unique	The index is used to enforce a unique constraint, and is maintained automatically by ElevateDB
Text Index	The index is a text index

Related DDL Statements

Statement

Description

CREATE INDEX	Creates a new index
CREATE TEXT INDEX	Creates a new text index
ALTER INDEX	Alters an existing index
DROP INDEX	Drops an existing index
RENAME INDEX	Renames an existing index

More Support Options

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Incident Reports

Roadmap