Is it possible to alter a table or drop a table using Hibernate Query Language ?

I dont want to use native SQL Query at those querries will be MySql specific.

Through forums I came to know about Hibernate class SchemaUpdate. But it does not
drop a table
drop a column
change a constraint on a column

& I want all of them

Is there any solution other than firing sql querries

There is no such support in HQL.

But I have successfully been able to programmatically generate org.hibernate.mapping.Table objects. This class has, among other things, the following useful methods:



You'll need lots of patience if you want to use this approach since most of it is undocumented. The API is also considered internal and it happens that there are incompatible changes between Hibernate versions.

I don't know how useful it may be but here is a link to the most important part where I am building up the Table object: http://base.thep.lu.se/browser/tags/2.1 ... .java#L800

This Table object is then used in other places, for example: http://base.thep.lu.se/browser/tags/2.1 ... .java#L612

Thanks for the fast reply
I will try..