The show.sql property is used for turning on and off the actual live SQL that is generated by Hibernate to store, retrieve and update objects in the underlying database. What you want is the DDL script that defines the database. I use an
ANT task to run hbm2ddl that looks like this:
As you can see this exports the DDL script to a file named database-ddl.sql in the directory ${schema.dir}. But you may be able to set the DDL generation in the main hibernate configuration file too with the hibernate.hbm2ddl.auto property. Look
HERE and search for hibernate.hbm2ddl.auto.