Icon Tables Table

Structure
CREATE TABLE "Tables"
(
"Name" VARCHAR(40) COLLATE "ANSI_CI",
"Description" CLOB COLLATE "ANSI"
"Attributes" CLOB COLLATE "ANSI",
"Version" DECIMAL(19,2),
"ReadOnly" BOOLEAN,
"Encrypted" BOOLEAN,
"RowSize" INTEGER,
"IndexPageSize" INTEGER,
"BlobBlockSize" INTEGER,
"PublishBlockSize" INTEGER,
"PublishCompression" INTEGER,
"MaxRowBufferSize" INTEGER,
"MaxIndexBufferSize" INTEGER,
"MaxBlobBufferSize" INTEGER,
"MaxPublishBufferSize" INTEGER,
"Published" BOOLEAN,
"PublishedOn" TIMESTAMP,
"PublishID" VARCHAR(60) COLLATE "ANSI_CI",
"DefaultsEnabled" BOOLEAN,
"GeneratedEnabled" BOOLEAN,
"CreateSQL" CLOB COLLATE "ANSI_CI",
"DropSQL" CLOB COLLATE "ANSI_CI"
)

CREATE INDEX "Name" ON "Tables"
("Name")

Description
This table contains the defined tables in an ElevateDB database.

Related DDL Statements
StatementDescription
CREATE TABLECreates a new table
ALTER TABLEAlters an existing table
DROP TABLEDrops an existing table
RENAME TABLERenames an existing table
Image