alter table command

[Arun R. S. Chandran]

Hi,

I am using hibernate. Is there any query we can use for altering a table?
If it is possible please reply me.

-Arun

[Paul Sturrock]

This is not something you should be doing with Hibernate. If you alter a table, you invalidate any object mapped to it.

Hibernate does support dynamically creating and updating scheama at start up. Have a look at the hbm2ddl properity in the configuration docs.

Hibernate also allows you to run native SQL (check the Session class's JavaDocs). But like I said, not a safe thing to do if the table is mapped.

[Arun R. S. Chandran]

Thanks Paul