Syntax Error near "CHANGE" in sqlite3
<p>I am attempting to execute the following (move a column to be the first one)</p>

<pre><code>import sqlite3
db = sqlite3.connect('adatabase.sqlite')
c = db.cursor()
c.execute('ALTER TABLE tab1 CHANGE COLUMN r r def FIRST')
</code></pre>

<p>Unfortunately I get this error</p>

<pre><code>Traceback (most recent call last):
   File "&lt;input&gt;", line 1, in &lt;module&gt;
OperationalError: near "CHANGE": syntax error
</code></pre>

<p>What could be? Thanks in advance</p>

<p><em>SQLite</em> does not support the <code>CHANGE COLUMN</code> feature.</p>

<blockquote>
  <p>Only the <code>RENAME TABLE</code> and <code>ADD COLUMN</code> variants of the <code>ALTER TABLE</code>
  command are supported</p>
</blockquote>

<p>See all missing features: <a href="http://www.sqlite.org/omitted.html" rel="nofollow">SQL Features That SQLite Does Not Implement</a></p>

python mysql database sqlite sqlite3