To check whether a table is locked or not in Teradata

For checking the lock, just run the following query on the table.

Sample code:
Lock Table DBNAME.TABLENAME write nowait
Select * from DBNAME.TABLENAME;

If this table is locked currently then the above statement would fail as Nowait will not wait for locks to be released on that table .