title: Unable to drop UNIQUE constraint
body: <p>I wanted to drop some constraints on a table. So, first I have to find out names of the constraints and then see which ones I want to drop. For the first task, I used the query - </p>
  
  <pre><code>SELECT * 
  FROM sys.indexes 
  WHERE object_id = OBJECT_ID('YourTableName')
  </code></pre>
  
  <p>I noted the name of a unique constraint on my table from the name column returned by this query. One of the constraint names is UNIQ_YourTableName_01. </p>
  
  <p>To drop that constraint, I used - </p>
  
  <pre><code>ALTER TABLE YourTableName
  DROP CONSTRAINT UNIQ_YourTableName_01
  </code></pre>
  
  <p>I get an error - UNIQ_YourTableName_01 is not a constraint. Could not drop constraint. See previous errors. How do I fix this ? </p>
  
  <p>Thanks.</p>