Structure

---

CREATE TABLE "LogEvents"
(
"Category" VARCHAR(15) COLLATE "ANSI_CI",
"Function" VARCHAR(40) COLLATE "ANSI_CI",
"ErrorCode" INTEGER,
"Description" CLOB COLLATE "ANSI",
"LogTimeStamp" TIMESTAMP,
"Version" DECIMAL(19,2),
"Build" INTEGER,
"ProductType" VARCHAR(40) COLLATE "ANSI_CI",
"User" VARCHAR(40) COLLATE "ANSI_CI",
"Process" VARCHAR(40) COLLATE "ANSI_CI",
"ThreadID" INTEGER,
"SessionID" INTEGER,
"SessionName" VARCHAR(40) COLLATE "ANSI_CI",
"SessionDescription" CLOB COLLATE "ANSI",
"IPAddress" VARCHAR(16) COLLATE "ANSI_CI",
"Encrypted" BOOLEAN
)

CREATE INDEX "Category" ON "LogEvents"
("Category")

CREATE INDEX "Version" ON "LogEvents"
("Version")
   
CREATE INDEX "User" ON "LogEvents"
("User")
   
CREATE INDEX "Process" ON "LogEvents"
("Process")

Description

---

This table contains the events currently logged by ElevateDB. The log events are generated by ElevateDB at various times, and can be informational messages, warning messages, or error messages. The current user must be granted the system-defined Administrators role in order to view this table. Please see the User Security topic for more information.

Related DDL Statements

---