title: Whats Better: Check if table exists or always fire create statement
body: <p>Is it OK to always fire the create statements rather than checking them like</p>
  
  <pre><code>SELECT * FROM INFORMATION_SCHEMA.TABLES 
  WHERE TABLE_NAME = 'my_table_name' 
  </code></pre>
  
  <p>in SQL SERVER CE and C#.
  Because irrespective of the approach, there is always a single query that will be fired. Isnt it ???</p>
  
  <p>I am using trasaction for creating all tables. So, I am sure if there is one table present, then definitely all of them are created.</p>
  
  <p>So if i use the same transaction, then the transaction will fail right at the very first create table statement: But is this good performance wise???</p>