title: Database design to create tables on the fly
body: <p>I need to create dynamic tables in the database on the fly. For example, in the database I will have tables named:</p>
  
  <pre><code>Table
  Column
  DataType
  TextData
  NumberData
  DateTimedata
  BitData
  </code></pre>
  
  <p>Here I can add a table in the table named table, then I can add all the columns to that table in the columns table and associate a datatype to each column. </p>
  
  <p>Basically I want to create tables without actually creating a table in the database. Is this even possible? If so, can you direct me to the right place so I can research? Also, I would prefer sql server or any free database software. </p>
  
  <p>Thanks</p>