SQLite's sqlite_sequence Table Sqlite_sequence table is also a system table for SQLite. The table is used to hold the maximum value of the ROWID for other tables. When the database is created, the Sqlite_sequence table is created automatically. The table includes two columns. The first column is name, which is used to store the name of the table. The second column is SEQ, which is used to hold the maximum value of the ROWID for the table. The maximum value for this value is 9223372036854775807. When the corresponding table adds a record, the table is automatically updated. When the table is deleted, the records corresponding to the table are also automatically deleted. If the value exceeds the maximum value, a sql_full error is caused. So, once the error is found, the user will not only have to check if the SQLite file is in a low disk space, but also check if the rowid of the table has reached the maximum value.
SQLite's sqlite_sequence table
