title: CREATE TABLE IF NOT EXISTS statement in SQLite
body: <p>I have a WPF application where I access a SQLite database via ADO.NET (<a href="http://adodotnetsqlite.sourceforge.net/" rel="noreferrer">http://adodotnetsqlite.sourceforge.net/</a>). So far everything works fine, but when I try to execute the following SQL:</p>
  
  <pre><code> sqlite_cmd.CommandText = "CREATE TABLE IF NOT EXISTS notes (id integer primary key, text varchar(100));";
   sqlite_cmd.ExecuteNonQuery();
  </code></pre>
  
  <p>I get the following exception:</p>
  
  <pre><code>An exception of type 'Finisar.SQLite.SQLiteException' occurred in SQLite.NET.dll but was not handled in user code.
  Additional information: near "NOT": syntax error
  </code></pre>
  
  <p>When I remove the <code>IF NOT EXISTS</code> part it works fine, but I want to create the table only if it is not already there. Is there anything I'm doing wrong?</p>