Structure

---

CREATE TABLE "ServerSessionLocks"
(
"SessionID" INTEGER,
"SessionName" VARCHAR(40) COLLATE "ANSI_CI",
"DatabaseName" VARCHAR(40) COLLATE "ANSI_CI",
"ObjectName" VARCHAR(40) COLLATE "ANSI_CI",
"ObjectType" VARCHAR(15) COLLATE "ANSI_CI",
"LockType" VARCHAR(15) COLLATE "ANSI_CI",
"Number" INTEGER
)

CREATE INDEX "SessionID" ON "ServerSessionLocks"
("SessionID")
   
CREATE INDEX "SessionName" ON "ServerSessionLocks"
("SessionName")

CREATE INDEX "DatabaseName" ON "ServerSessionLocks"
("DatabaseName")

Description

---

This table reflects all locks currently acquired by all of 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.

The LockType column values are as follows:


Related DDL Statements

---