title: Can I alter a column in an sqlite table to AUTOINCREMENT after creation?
body: <p>Can I make a field <code>AUTOINCREMENT</code> after made a table? For example, if you create a table like this:</p>
  
  <pre><code>create table person(id integer primary key, name text);
  </code></pre>
  
  <p>Then later on realise it needs to auto increment. How do I fix it, ie in MySQL you can do:</p>
  
  <pre><code>alter table person modify column id integer auto_increment
  </code></pre>
  
  <p>Is table creation the only opportunity to make a column <code>AUTOINCREMENT</code>?</p>