[ https://issues.apache.org/jira/browse/OPENJPA-1132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12718284#action_12718284 ] Michael Dick commented on OPENJPA-1132: --------------------------------------- Looks like ALTER TABLE xxx DROP FOREIGN KEY yyy should work [1]. I'm not sure if there's a more general name we can use though. [1] http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html > Dropping constraints fails on MySQL > ----------------------------------- > > Key: OPENJPA-1132 > URL: https://issues.apache.org/jira/browse/OPENJPA-1132 > Project: OpenJPA > Issue Type: Bug > Components: sql > Affects Versions: 2.0.0 > Environment: MySQL 5.1 > Reporter: Milosz Tylenda > Assignee: Milosz Tylenda > > MySQL rejects our DROP CONSTRAINT statements, it requires different syntax. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.