21 June 2018        Add to Favorites   Report

Teradata locks - How to find if a table is locked?

Scenario: Is there a way to know if a table is locked and what kind of lock is currently on a table?

We can do something like the following:

Lock Table dbName.myTable for Access nowait
Select * from dbName.myTable;

If the table is locked, you will get error 7423, "Object already locked and NOWAIT. Transaction Aborted."

Read great educational content like this and a lot more ! Create my free account now 🎁