title: create table if not exists, insert columns if missing, best way
body: <p>I need to create a table if it doesnt exist, and add missing columns in the proper order if the table already exists.</p>
  
  <p>I know how to do it with lots of queries, and if statements and so on, but what I am asking here is what the best solution would be.. Maybe there is a special query to do this, or a smart way.</p>
  
  <p>I would do it this way:</p>
  
  <ul>
  <li><p>create table if not exists (all columns as they should be)</p></li>
  <li><p>compare all the columns (if some are missing they will be added, else not)</p></li>
  </ul>
  
  <p>Is this the best way or are there better ways to do it? </p>
  
  <hr>
  
  <p><strong>ADDITIONAL INFO</strong></p>
  
  <p>the colums need to be added at the right position. I have a list of strings representing all the columns in the proper order. using vb.net I am iterating through these strings.</p>