title: Rename table in sqlite
body: <p>I am trying to rename a table in my app's <code>sqlite</code> database. For that I am using the following command:</p>
  
  <pre><code>ourDatabase.rawQuery("ALTER TABLE " + oldName + " RENAME TO " + newName,
                  null);
  </code></pre>
  
  <p>where <code>oldName</code> is old name of the table, <code>newName</code> is the new name of table and <code>ourDatabase</code> is an instance of <code>SQLiteDatabase</code>. But this is not working.</p>
  
  <p>What's the mistake ?</p>
  
  <p>Thanks.</p>