如何检查表上保存的锁

SELECT * FROM information_schema.TABLE_LOCKS WHERE TABLE_SCHEMA = 'your_database_name' AND TABLE_NAME = 'your_table_name';

SELECT * FROM sys.dm_tran_locks WHERE database_id = DB_ID('your_database_name') AND resource_associated_entity_id = OBJECT_ID('your_table_name');

SELECT * FROM pg_locks WHERE database = current_database() AND relation = 'your_table_name'::regclass::oid;

SELECT * FROM v$locked_object WHERE object_name = 'your_table_name';