Check a Table is locked or not in Teradata

Lock Table DBNAME.TABLENAME write nowait Select * from DBNAME.TABLENAME sample 1;

 

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

Comments