Do you need both primary key AND autoincrement for creating table in SQLite?

Question

Or can you just use one or the other? I'd like to avoid redundancy while ensuring uniqueness by just using PRIMARY KEY but am wondering whether the added rows will AUTOINCREMENT by default.

Come on. Just try or google it. – juergen d Aug 28 '16 at 18:19 — juergen d, Aug 28 '16 at 18:19

score 2 · Accepted Answer · answered Aug 28 '16 at 18:18

2

Yes, added rows will have automatically generated values for primary keys if you don't supply an explicit non-null value yourself. The algorithm for generating such values is slightly different with and without AUTOINCREMENT keyword.

answered Aug 28 '16 at 18:18

laalto

150,114
66
286
303

Do you need both primary key AND autoincrement for creating table in SQLite?

1 Answers1