Sql

Search

how to check table lock

SELECT
OBJECT_NAME(p.OBJECT_ID) AS TableName,
resource_type, resource_description
FROM
sys.dm_tran_locks l
JOIN sys.partitions p ON l.resource_associated_entity_id = p.hobt_id

Comment

PREVIOUS	NEXT

Code Example
Sql :: add primary key with auto increment to existing table column mysql
Sql :: plpgsql create function
Sql :: function in plsql
Sql :: oracle apex warn on unsaved changes
Sql :: mariadb hours between two dates
Sql :: sql server alter table add column tinyint
Sql :: check table exist postgresql
Sql :: install mysql on ubuntu
Sql :: sql insert from excel
Sql :: sql server convert date to weekday
Sql :: sort by sql
Sql :: sql datetime format
Sql :: postgresql get date now
Sql :: change filed order in mysql
Sql :: json extract
Sql :: download sql server 2016
Sql :: snowflake drop column
Sql :: how to get 30 days previous date in mysql
Sql :: delete a temporary table mysql
Sql :: oracle free up space in tablespace
Sql :: mysql run sql file
Sql :: Converting mysql tables to charset utf8mb4
Sql :: get cpu details sql
Sql :: groupby error in mysql
Sql :: sql server remove primary key without dropping table
Sql :: oracle dependencies table
Sql :: sql if example
Sql :: SQL COUNT() With HAVING Clause
Sql :: alter table add foreign key mariadb example
Sql :: alter table query sql server change column

Search

SQL

how to check table lock

ADD CONTENT