Structure

---

CREATE TABLE "TableColumns"
(
"TableName" VARCHAR(40) COLLATE "ANSI_CI",
"Name" VARCHAR(40) COLLATE "ANSI_CI",
"Description" CLOB COLLATE "ANSI",
"Type" VARCHAR(30) COLLATE "ANSI_CI",
"Collation" VARCHAR(40) COLLATE "ANSI_CI",
"Length" INTEGER,
"Precision" INTEGER,
"Scale" INTEGER,
"BlobCompression" INTEGER,
"Nullable" BOOLEAN,
"ErrorCode" INTEGER,
"ErrorMessage" CLOB COLLATE "ANSI",
"Generated" BOOLEAN,
"GeneratedWhen" VARCHAR(15) COLLATE "ANSI_CI",
"GenerateExpr" CLOB COLLATE "ANSI",
"Identity" BOOLEAN,
"IdentitySeed" INTEGER,
"IdentityIncrement" INTEGER,
"Computed" BOOLEAN,
"ComputeExpr" CLOB COLLATE "ANSI",
"DefaultExpr" CLOB COLLATE "ANSI",
"OrdinalPos" INTEGER,
"CreateSQL" CLOB COLLATE "ANSI_CI",
"DropSQL" CLOB COLLATE "ANSI_CI"
)

CREATE INDEX "TableName" ON "TableColumns"
("TableName")

CREATE INDEX "Name" ON "TableColumns"
("Name")

Description

---

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

The GeneratedWhen column values are as follows:


Related DDL Statements

---