Icon Updates Table

Structure
CREATE TABLE "Updates"
(
"Name" VARCHAR(255) COLLATE "ANSI_CI",
"Description" CLOB COLLATE "ANSI",
"DatabaseName" VARCHAR(40) COLLATE "ANSI_CI",
"DatabasePath" VARCHAR(255) COLLATE "ANSI_CI",
"CreatedOn" TIMESTAMP,
"CreatedBy" VARCHAR(40) COLLATE "ANSI",
"CompressionLevel" INTEGER,
"Size" BIGINT,
"NumTables" INTEGER,
"Tables" CLOB COLLATE "ANSI"
)

CREATE INDEX "Name" ON "Updates"
("Name")

Description
The updates are dynamic in ElevateDB and this table reflects the update files present in the current updates store. The updates store can be changed or modified using the SET UPDATES STORE statement.

Related DDL Statements
StatementDescription
SET UPDATES STORESets the current updates store
Image