title: MySQL Drop Constraint Syntax Error
body: <p>I'm using MySQL 5.1.36 I'm trying to drop a constraint named <code>chk1</code> but MySQL reports an syntactical  error. I looked it up but am unable to find it. What is the error?</p>
  
  <pre><code>mysql&gt; create database house;
  Query OK, 1 row affected (0.01 sec)
  mysql&gt; use house;
  Database changed
  mysql&gt; create table member(age integer);
  Query OK, 0 rows affected (0.05 sec)
  
  mysql&gt; alter table member add constraint chk1 check(age&gt;0);
  Query OK, 0 rows affected (0.08 sec)
  Records: 0  Duplicates: 0  Warnings: 0
  
  mysql&gt; alter table member drop constraint chk1;
  ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'constraint chk1' at line 1
  
  mysql&gt; alter table member drop check chk1;
  ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'check chk1' at line 1
  </code></pre>