Tip: Use AUTOINCREMENT to create primary keys

Using the AUTOINCREMENT feature to generate primary key values is faster than other methods because the value is generated by the database server.

You can use the AUTOINCREMENT default for any column in which you want to maintain unique values.