DELETE FROM sqlite_sequence; CREATE TABLE t10a(a INTEGER PRIMARY KEY AUTOINCREMENT, b UNIQUE); INSERT INTO t10a VALUES(888,9999); CREATE TABLE t10b(x INTEGER PRIMARY KEY AUTOINCREMENT, y UNIQUE); INSERT INTO t10b SELECT * FROM t10a; SELECT * FROM sqlite_sequence; CREATE TABLE t11(a INTEGER PRIMARY KEY AUTOINCREMENT,b UNIQUE); INSERT INTO t11(a,b) VALUES(2,3),(5,6),(4,3),(1,2) ON CONFLICT(b) DO UPDATE SET a=a+1000; SELECT seq FROM sqlite_sequence WHERE name='t11'; CREATE TABLE t1(i INTEGER PRIMARY KEY AUTOINCREMENT, j); CREATE TABLE t2(i INTEGER PRIMARY KEY AUTOINCREMENT, j); CREATE TABLE t3(i INTEGER PRIMARY KEY AUTOINCREMENT, j); INSERT INTO t1 VALUES(NULL, 1); INSERT INTO t2 VALUES(NULL, 2); INSERT INTO t3 VALUES(NULL, 3); SELECT name FROM sqlite_sequence; UPDATE sqlite_sequence SET name=NULL WHERE name='t2'; INSERT INTO t3 VALUES(NULL, 4); DELETE FROM t3; INSERT INTO t3 VALUES(NULL, 5); SELECT * FROM t3;