Structure

---

CREATE TABLE "ConstraintColumns"
(
"TableName" VARCHAR(40) COLLATE "ANSI_CI",
"ConstraintName" VARCHAR(40) COLLATE "ANSI_CI",
"ColumnName" VARCHAR(40) COLLATE "ANSI_CI",
"OrdinalPos" INTEGER
)

CREATE INDEX "TableName" ON "ConstraintColumns"
("TableName")

CREATE INDEX "ConstraintName" ON "ConstraintColumns"
("ConstraintName")

CREATE INDEX "ColumnName" ON "ConstraintColumns"
("ColumnName")

Description

---

This table contains the columns that make up the defined primary, unique, or foreign key constraints for the tables in an ElevateDB database.

Related DDL Statements

---