title: Sqlite if Table Exists Then Rename
body: <p>Amazing, I expected to google and find an answer to this within a few seconds, but I've now spent 1/2 hour and tried many methods:</p>
  
  <p>I need to rename a table if it exists, here's a couple of attempts:</p>
  
  <pre><code>var sql = "IF NOT EXISTS 'zones' ALTER TABLE 'sensors' RENAME TO 'zones';";
  var sql = "ALTER TABLE if exists 'sensors' RENAME TO 'zones';";
  </code></pre>
  
  <p>Any idea how I can achieve this ??</p>