SQLite Result Codes

Integer result codes returned by SQLite C API functions. Primary result codes occupy the low 8 bits; extended result codes add detail in the higher bits and are a superset of the primary codes.

65 codes

• SQLITE_ABORT Callback requested abort
• SQLITE_AUTH Authorisation denied
• SQLITE_BUSY Database file locked
• SQLITE_BUSY_RECOVERY Busy during WAL recovery
• SQLITE_BUSY_SNAPSHOT Busy snapshot conflict
• SQLITE_CANTOPEN Unable to open database
• SQLITE_CANTOPEN_FULLPATH Cannot resolve full path
• SQLITE_CANTOPEN_ISDIR Cannot open: is a directory
• SQLITE_CANTOPEN_SYMLINK Cannot open symlink
• SQLITE_CONSTRAINT Constraint violation
• SQLITE_CONSTRAINT_CHECK CHECK constraint failed
• SQLITE_CONSTRAINT_FOREIGNKEY FOREIGN KEY constraint failed
• SQLITE_CONSTRAINT_NOTNULL NOT NULL constraint failed
• SQLITE_CONSTRAINT_PRIMARYKEY PRIMARY KEY constraint failed
• SQLITE_CONSTRAINT_ROWID ROWID constraint failed
• SQLITE_CONSTRAINT_TRIGGER RAISE function called by trigger
• SQLITE_CONSTRAINT_UNIQUE UNIQUE constraint failed
• SQLITE_CORRUPT Disk image malformed
• SQLITE_CORRUPT_INDEX Index corruption
• SQLITE_CORRUPT_SEQUENCE Sequence table corruption
• SQLITE_CORRUPT_VTAB Virtual table corruption
• SQLITE_DONE Execution complete
• SQLITE_EMPTY Database empty
• SQLITE_ERROR Generic error
• SQLITE_ERROR_MISSING_COLLSEQ Missing collating sequence
• SQLITE_ERROR_RETRY Retry
• SQLITE_FORMAT Auxiliary database format error
• SQLITE_FULL Database full
• SQLITE_INTERNAL Internal error
• SQLITE_INTERRUPT Interrupted
• SQLITE_IOERR I/O error
• SQLITE_IOERR_DELETE I/O error deleting file
• SQLITE_IOERR_FSYNC I/O error during fsync
• SQLITE_IOERR_LOCK I/O error obtaining lock
• SQLITE_IOERR_MMAP I/O error memory-mapping
• SQLITE_IOERR_NOMEM I/O layer out of memory
• SQLITE_IOERR_READ I/O error reading
• SQLITE_IOERR_SEEK I/O error seeking
• SQLITE_IOERR_SHORT_READ Short read
• SQLITE_IOERR_TRUNCATE I/O error truncating
• SQLITE_IOERR_WRITE I/O error writing
• SQLITE_LOCKED Table locked
• SQLITE_LOCKED_SHAREDCACHE Locked by shared cache
• SQLITE_MISMATCH Data type mismatch
• SQLITE_MISUSE Library used incorrectly
• SQLITE_NOLFS Large file support missing
• SQLITE_NOMEM Out of memory
• SQLITE_NOTADB Not a database file
• SQLITE_NOTFOUND Not found
• SQLITE_NOTICE Notification
• SQLITE_NOTICE_RECOVER_WAL Notice: WAL recovery
• SQLITE_OK OK
• SQLITE_PERM Permission denied
• SQLITE_PROTOCOL Locking protocol error
• SQLITE_RANGE Column index out of range
• SQLITE_READONLY Read-only database
• SQLITE_READONLY_CANTLOCK Read-only: cannot lock
• SQLITE_READONLY_DBMOVED Read-only: database moved
• SQLITE_READONLY_RECOVERY Read-only: WAL recovery needed
• SQLITE_READONLY_ROLLBACK Read-only: rollback required
• SQLITE_ROW Row available
• SQLITE_SCHEMA Schema changed
• SQLITE_TOOBIG String or BLOB too large
• SQLITE_WARNING Warning
• SQLITE_WARNING_AUTOINDEX Warning: automatic index created