title: SQL Server Error: "%" is not a constraint. Could not drop constraint. See previous errors
body: <p>I'm using Microsoft SQL Server 2005, and am relatively new to SQL in general.</p>
  
  <p>There is a relationship between two tables, "Resources" and "Group_Resources", in the database "Information".  Resources has a foreign key, "id", in Group_Resources, named "resource_id".  There is a foreign key constraint, "fk_gr_res_resources", between the two.</p>
  
  <p>I'm established as the database owner, and have full read/write/create/delete permissions.</p>
  
  <p>I want to delete the foreign key constraint, so I executed the following query:</p>
  
  <pre><code>ALTER TABLE [Information].[group_resources] DROP CONSTRAINT fk_gr_res_resources
  </code></pre>
  
  <p>and received the following error: </p>
  
  <blockquote>
    <p>'fk_gr_res_resources' is not a constraint. Could not drop constraint. See previous errors.</p>
  </blockquote>
  
  <p>I'm confused, because it is a constraint, and there are no spelling errors.  Am I going about deleting this improperly?  Am I deleting the constraint from the incorrect table? Any suggestions would be greatly appreciated, &amp; please don't flame me: I am new to SQL after all.  </p>