I get syntax error when I want to reset primary key of sqlite table

Asked Mar 26 '20 at 14:50

Active Mar 26 '20 at 15:12

Viewed 40 times

I deleted some rows in my database, and I need to reset primary key. I use

ALTER TABLE Instructors AUTO_INCREMENT=1;

but I get syntax error.

Result: near "AUTO_INCREMENT": syntax error At line 1: ALTER TABLE [Instructors] AUTO_INCREMENT

edited Mar 26 '20 at 15:12

asked Mar 26 '20 at 14:50

Elham Amini

Does this answer your question? [SQLite add Primary Key](https://stackoverflow.com/questions/946011/sqlite-add-primary-key) – mutantkeyboard Mar 26 '20 at 15:18
That's not valid sqlite syntax. Where did you get the idea it was? – Shawn Mar 26 '20 at 15:36
Hello Elham, Welcome to SO. I think you are missing the field where you want to add the auto increment – JCalcines Mar 26 '20 at 16:01

0 Answers0