reset keys in sql 1

reset keys in sql

UPDATE SQLITE_SEQUENCE SET SEQ=0 WHERE NAME='table_name';

Here is what the above code is Doing:
1. It’s getting a connection to the database.
2. It’s getting a cursor from the connection.
3. It’s executing the SQL statement.
4. It’s committing the changes to the database.
5. It’s closing the connection.

Similar Posts