System and catalog stored procedures
970
table_name A char(128) parameter representing a table name. The
procedure returns information only about the specified tables. The default
value is NULL, in which case information is returned about all tables.
If you do not include owner, it is assumed that the table is owned by the
caller of the procedure.
max_locks An integer parameter representing the maximum number of
locks for which to return information. The default value is 1000. The value -
1 means return all lock information.
The information returned for each lock includes the following:
connection ID The connection ID that has the lock.
user name The user connected through connection ID.
table name The table on which the lock is held.
lock_name The LockName value identifying the lock. This value can be
matched with
sa_conn_info
output to determine the responsible locks in a
blocking situation.
$ For more information, see "Connection-level properties" on page 1090,
and "sa_conn_info system procedure" on page 964.
lock type The lock type is a string of characters indicating the type of
lock. These characters are:
♦
S Shared
♦
E Exclusive
♦
P Phantom
♦
A Anti-phantom
All locks listed have exactly one of S or E specified, and may also have P, A,
or both. If a lock is a phantom or anti-phantom lock, a qualifier is added to
the lock type. The qualifier is as follows:
♦
T The lock is with respect to a sequential scan
♦
* The lock is with respect to all scans.
♦
nnn An index number. The lock is with respect to a particular index.
sa_reset_identity system procedure
Allows the next available identity value to be set for a table.
sa_reset_identity ( [
table_name
], [
owner
], [
new_identity_value
] )
Function
Syntax
To Next Page
Loading...