Hibernate version: 2.1.6

Name and version of the database you are using: MySQL 4.0.20

I set up a 1-1 mapping between two classes and the following
sql is generated as first line of my sql file:

The generated SQL (show_sql=true):

// there is more, but this is the line in question:

alter table TRADDRS drop constraint FKEB2CBEC414381;

When I source the sql in the mysql interpreter, it chokes.
I referred to syntax for 'alter table' in mysql manual and
didn't see any alter table....drop contraint...
but did see alter table...drop index.

I changed generated line to alter table ...drop index
and it worked.

Are we looking at a bug here?

Rob