title: SQL Server: drop a FK constraint, which is not foreign key
body: <p>I am using SQL Server 2008 and its Management Studio. I am doing a web project, which has a tool to automate the tables/relationships creation. </p>
  
  <p>My web project reveals this error:</p>
  
  <blockquote>
    <p>Unsuccessful: alter table Tester add constraint FK_c6c4bf4s2rvp56a32nnruww2b foreign key (game) references Game</p>
    
    <p>Column 'Game.id' is not the same data type as referencing column 'Tester.game' in foreign key 'FK_c6c4bf4s2rvp56a32nnruww2b'</p>
  </blockquote>
  
  <p>However, when I ran the following in the management studio:</p>
  
  <pre><code>ALTER TABLE dbo.Tester DROP CONSTRAINT FK_c6c4bf4s2rvp56a32nnruww2b
  </code></pre>
  
  <p>I get the following:</p>
  
  <blockquote>
    <p>Msg 3728, Level 16, State 1, Line 1<br>
    'FK_c6c4bf4s2rvp56a32nnruww2b' is not a constraint.<br>
    Msg 3727, Level 16, State 0, Line 1<br>
    Could not drop constraint. See previous errors.</p>
  </blockquote>
  
  <p>I am confused. What type of constraint is <code>FK_c6c4bf4s2rvp56a32nnruww2b</code>?</p>
  
  <p>How can I remove it?</p>
  
  <p>Thanks and regards.</p>