title: How to see the schema sql (DDL) in spring boot?
body: <p>How can I see the DDL SQL generated by Hibernate for building the schema from the JPA mappings? I am using the embedded HSQL db.</p>
  
  <p>I tried the following and none of them worked in Spring-Boot 1.3.5.RELEASE. </p>
  
  <ul>
  <li>Adding the following to application.properties file
  
  <ul>
  <li>debug=true</li>
  <li>spring.jpa.properties.hibernate.show_sql=true</li>
  </ul></li>
  <li>Set org.hibernate.SQL level to debug in logback.xml</li>
  <li>Steps listed at <a href="http://docs.spring.io/spring-boot/docs/current/reference/html/howto-database-initialization.html" rel="noreferrer">http://docs.spring.io/spring-boot/docs/current/reference/html/howto-database-initialization.html</a></li>
  </ul>
  
  <p>Those only show me the sql issued by Hibernate for queries. I am looking for the DDL schema sql issued by Hibernate due the following property: </p>
  
  <pre><code>spring.jpa.hibernate.ddl-auto=create-drop
  </code></pre>