LockColumns Class

Provides column names for result table from built-in stored procedure DB_ADMIN.GET_LOCKS.

Pascal

LockColumns = class;

C++

class LockColumns;

File

LockColumns.cs

Description

LockColumns provides the column names for the result table from the built-in stored procedure DB_ADMIN.GET_LOCKS. The columns of the result table are:

Constant	Description
NAME	Name of object that lock applies to. Typically this is the name of a table.
TYPE	The type of lock, which can be table or row.
GRANTED	Indicates whether or not the lock has been granted.
SHARED	Indicates whether or not the lock can be shared with another shared lock. If false, this is an exclusive lock that cannot share.
USER	User that holds the lock.
ROW	If the TYPE column is set to row, this is the row that the lock applies to. Otherwise this is set to null.
COMP_MASK	If the TYPE column is set to TABLE, this is set to a collection of bits that this table lock is compatible with.
LOCK_MASK	If the TYPE column is set to TABLE, this will be set to a collection of bits that this table lock is locking.
ROW_LOCK	Row lock.
TABLE_LOCK	Table lock.