Icon Backups Table

Structure
CREATE TABLE "Backups"
(
"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,
"IncludesCatalog" BOOLEAN,
"NumTables" INTEGER,
"Tables" CLOB COLLATE "ANSI"
)

CREATE INDEX "Name" ON "Backups"
("Name")

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

Related DDL Statements
StatementDescription
SET BACKUPS STORESets the current backups store
Image