Icon Files Table

Structure
CREATE TABLE "Files"
(
"Name" VARCHAR(255) COLLATE "ANSI_CI",
"CreatedOn" TIMESTAMP,
"ModifiedOn" TIMESTAMP,
"Size" LARGEINT)

CREATE INDEX "Name" ON "Files"
("Name")

CREATE INDEX "CreatedOn" ON "Files"
("CreatedOn")

CREATE INDEX "ModifiedOn" ON "Files"
("ModifiedOn")

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

Related DDL Statements
StatementDescription
SET FILES STORESets the current files store
COPY FILECopies a file from one file to another file, either in the same store or in a different store
RENAME FILERenames a file to a different name in a store
DELETE FILEDeletes a file from a store
Image