SQLite statement for creating an Autoincrement field in its command window
I am working in SQLite command window. What can be the SQLite statement for creating an Autoincrement field
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pravin MorePosted Nov 18, 2011, 12:40 AM
Hi monika,
INTEGER PRIMARY KEY AUTOINCREMENT
have you tried above....
The ROWID chosen for the new row is at least one larger than the largest ROWID that has ever before existed in that same table.