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

---