Structure

---

CREATE TABLE "ServerSessions"
(
"ID" INTEGER,
"Name" VARCHAR(40) COLLATE "ANSI_CI",
"Description" CLOB COLLATE "ANSI",
"Created" TIMESTAMP,
"LastConnected" TIMESTAMP,
"Connected" BOOLEAN,
"Encrypted" BOOLEAN,
"IPAddress" VARCHAR(16) COLLATE "ANSI_CI",
"User" VARCHAR(40) COLLATE "ANSI_CI",
"Process" VARCHAR(40) COLLATE "ANSI_CI"
)

CREATE INDEX "ID" ON "ServerSessions"
("ID")
   
CREATE INDEX "Name" ON "ServerSessions"
("Name")

Description

---

This table reflects the sessions that are present on the ElevateDB server that the current session is logged in to. 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

---