title: How can I replicate "SHOW TABLES" in Hibernate?
body: <p>I'm trying to iterate over all of my tables so I can truncate each one (at the beginning of each of my JBehave tests).</p>
  
  <p>I thought I would be able to:</p>
  
  <pre><code>List&lt;String&gt; allTables = session.createSQLQuery("SHOW TABLES").list();
  </code></pre>
  
  <p>But hibernate throws a SQLGrammarException, complaining that "Column &apos;TABLE_NAME&apos; not found."</p>
  
  <p>I guess this is because the "show tables" query doesn't actually return a list of strings.  Is there another way to get a list of all my tables using Hibernate?  </p>