I am not able to select, drop or delete any rows from a teradata table.
I think it is locked, can anyone please suggest a way in unlocking this table.
It could be locked or your query could be blocked.
Run showlocks t check for HUT locks. Run Release lock db.tb, override; to release
Use viewpoint to view blocking.
To confirm that you are being blocked, try a SELECT with an ACCESS LOCK:
Locking row for access select count(*) from .......
If this works, then, yes, you are probably blocked. Use Viewpoint to chase down the blocking lock