Skip to main content

How do we identify which table columns called TablId and/or TablNum equates to in Aculocks1

How do we identify which table columns called TablId and/or TablNum equates to in Aculocks1

sorry that should have been TableNum and tableId

How do we identify which table columns called TablId and/or TablNum equates to in Aculocks1

The first locking table is called AcuLocks; it holds the record locks. The columns in this table are the DBID, the Table ID, the Process ID of the process holding the lock, and the primary key of the record that is locked. There is a unique index on the DBID, the Table ID, and the Key Value, so that inserts into this table are automatically rejected if another user holds a lock on the row in question. This also provides the Database Administrator the information needed to determine who has locks set, and whether the user in question still has a connection to the server.

How do we identify which table columns called TablId and/or TablNum equates to in Aculocks1

And to get the table name execute this query:
select Object_Name(<TableID>)