title: How to unlock table in SQL Server 2012?
body: <p>I created table in SQL Server 2012 and when I execute </p>
  
  <pre><code>select * from tableName 
  </code></pre>
  
  <p>it is taking a long time and some time returns no result.</p>
  
  <p>Currently it has only 1 row. After searching I know it is being locked so please help how to unlock it or drop it?</p>