title: retrieve table and column names from code
body: <p>I need to retrieve the table names and all of the subsequent columns to be added into the tables to do it manually, given from the code I've got. I can gather all of the table names quite easily (I believe) but I can't see exactly what I'm looking for column wise. I need help knowing the column data and datatype (old mysql database with the tables was lost)</p>
  
  <pre><code>useroptions.vb :http://pastebin.com/84SxTzfz
  useroptionscommon.vb :http://pastebin.com/2rxf3e2y
  Connections.vb :http://pastebin.com/CpWqt2m8
  userpersistence.vb :http://pastebin.com/TaAex24Q
  streamprocessor.vb :http://pastebin.com/Tazr1s8p
  serverpersistance.vb :http://pastebin.com/qvnCN2PY
  frontpagehub.vb :http://pastebin.com/FYyLH4qP
  </code></pre>
  
  <p>Even if somebody could tell me what to look for to figure out the tables I need to add, columns and datatype of the columns. I would greatly appreciate it.
  I've spent days now trying to reconstruct the database and find ways to figure out everything I need and I've gotten a few things up and running but it's these in particular I'm having trouble with.</p>