How do you find whether table is locked or not? TDWORLD | May 24, 2014 | Important Queries | No Comments 4) How do you whether table is locked or not? Answers) Just run the following query on the table. Lock Table DBNAME.TABLENAME write nowait Select * from DBNAME.TABLENAME; Related Posts How to generate a list of tables which are of type " SET " in Teradata ? No Comments | May 24, 2014 Details for Access & Access Rights for a User in Teradata No Comments | May 24, 2014 How to find the space utilized by particular database in teradata ? No Comments | May 24, 2014 How can you find the Table Space Size of your table across all AMP No Comments | May 24, 2014 About The Author tdworld2013 Add a Comment Cancel reply Your email address will not be published. Required fields are marked *Comment:*Name:* Email Address:* Website: Save my name, email, and website in this browser for the next time I comment.