title: Find all tables in a database with Java
body: <p>I'm trying to get all the table names in my database back through Java but I am having problems using the Result Set.
  The below works and I can see the info listed when I inspect the result set. 
  How do i get the table names from the result set into a collection?.</p>
  
  <pre><code>ResultSet rs;
  rs = stat.executeQuery("SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES");
  </code></pre>