Identity and autoincrement

Question

Please I'm frequent with the ms SQL server
But presently I'm using SQLite.
I'm not frequent wit SQLite and am trying to use identity and the code did not work but did not auto-increment,
I tried using identity and auto-increment together, but now I got an error.
Please what do I do.
The code is on my Page

Answer 1

It's syntax difference that is causing the problem. IDENTITY is known only by MSSQL, SQLite has their own way for defining auto increment column attribute.

https://www.tutorialspoint.com/sqlite/sqlite_using_autoincrement.htm