How to unlock table in SQL Server 2012?
<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>