Small. Fast. Reliable.
Choose any three.
Home
Menu
About
Documentation
Download
License
Support
Purchase
Search
About
Documentation
Download
Support
Purchase
Search Documentation
Search Changelog
SQLite C Interface
List Of Constants:
Also available:
list of error codes
SQLITE_ABORT
SQLITE_ABORT_ROLLBACK
SQLITE_ACCESS_EXISTS
SQLITE_ACCESS_READ
SQLITE_ACCESS_READWRITE
SQLITE_ALTER_TABLE
SQLITE_ANALYZE
SQLITE_ANY
SQLITE_ATTACH
SQLITE_AUTH
SQLITE_AUTH_USER
SQLITE_BLOB
SQLITE_BUSY
SQLITE_BUSY_RECOVERY
SQLITE_BUSY_SNAPSHOT
SQLITE_BUSY_TIMEOUT
SQLITE_CANTOPEN
SQLITE_CANTOPEN_CONVPATH
SQLITE_CANTOPEN_DIRTYWAL
SQLITE_CANTOPEN_FULLPATH
SQLITE_CANTOPEN_ISDIR
SQLITE_CANTOPEN_NOTEMPDIR
SQLITE_CANTOPEN_SYMLINK
SQLITE_CHECKPOINT_FULL
SQLITE_CHECKPOINT_PASSIVE
SQLITE_CHECKPOINT_RESTART
SQLITE_CHECKPOINT_TRUNCATE
SQLITE_CONFIG_COVERING_INDEX_SCAN
SQLITE_CONFIG_GETMALLOC
SQLITE_CONFIG_GETMUTEX
SQLITE_CONFIG_GETPCACHE
SQLITE_CONFIG_GETPCACHE2
SQLITE_CONFIG_HEAP
SQLITE_CONFIG_LOG
SQLITE_CONFIG_LOOKASIDE
SQLITE_CONFIG_MALLOC
SQLITE_CONFIG_MEMDB_MAXSIZE
SQLITE_CONFIG_MEMSTATUS
SQLITE_CONFIG_MMAP_SIZE
SQLITE_CONFIG_MULTITHREAD
SQLITE_CONFIG_MUTEX
SQLITE_CONFIG_PAGECACHE
SQLITE_CONFIG_PCACHE
SQLITE_CONFIG_PCACHE2
SQLITE_CONFIG_PCACHE_HDRSZ
SQLITE_CONFIG_PMASZ
SQLITE_CONFIG_ROWID_IN_VIEW
SQLITE_CONFIG_SCRATCH
SQLITE_CONFIG_SERIALIZED
SQLITE_CONFIG_SINGLETHREAD
SQLITE_CONFIG_SMALL_MALLOC
SQLITE_CONFIG_SORTERREF_SIZE
SQLITE_CONFIG_SQLLOG
SQLITE_CONFIG_STMTJRNL_SPILL
SQLITE_CONFIG_URI
SQLITE_CONFIG_WIN32_HEAPSIZE
SQLITE_CONSTRAINT
SQLITE_CONSTRAINT_CHECK
SQLITE_CONSTRAINT_COMMITHOOK
SQLITE_CONSTRAINT_DATATYPE
SQLITE_CONSTRAINT_FOREIGNKEY
SQLITE_CONSTRAINT_FUNCTION
SQLITE_CONSTRAINT_NOTNULL
SQLITE_CONSTRAINT_PINNED
SQLITE_CONSTRAINT_PRIMARYKEY
SQLITE_CONSTRAINT_ROWID
SQLITE_CONSTRAINT_TRIGGER
SQLITE_CONSTRAINT_UNIQUE
SQLITE_CONSTRAINT_VTAB
SQLITE_COPY
SQLITE_CORRUPT
SQLITE_CORRUPT_INDEX
SQLITE_CORRUPT_SEQUENCE
SQLITE_CORRUPT_VTAB
SQLITE_CREATE_INDEX
SQLITE_CREATE_TABLE
SQLITE_CREATE_TEMP_INDEX
SQLITE_CREATE_TEMP_TABLE
SQLITE_CREATE_TEMP_TRIGGER
SQLITE_CREATE_TEMP_VIEW
SQLITE_CREATE_TRIGGER
SQLITE_CREATE_VIEW
SQLITE_CREATE_VTABLE
SQLITE_DBCONFIG_DEFENSIVE
SQLITE_DBCONFIG_DQS_DDL
SQLITE_DBCONFIG_DQS_DML
SQLITE_DBCONFIG_ENABLE_FKEY
SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER
SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION
SQLITE_DBCONFIG_ENABLE_QPSG
SQLITE_DBCONFIG_ENABLE_TRIGGER
SQLITE_DBCONFIG_ENABLE_VIEW
SQLITE_DBCONFIG_LEGACY_ALTER_TABLE
SQLITE_DBCONFIG_LEGACY_FILE_FORMAT
SQLITE_DBCONFIG_LOOKASIDE
SQLITE_DBCONFIG_MAINDBNAME
SQLITE_DBCONFIG_MAX
SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE
SQLITE_DBCONFIG_RESET_DATABASE
SQLITE_DBCONFIG_REVERSE_SCANORDER
SQLITE_DBCONFIG_STMT_SCANSTATUS
SQLITE_DBCONFIG_TRIGGER_EQP
SQLITE_DBCONFIG_TRUSTED_SCHEMA
SQLITE_DBCONFIG_WRITABLE_SCHEMA
SQLITE_DBSTATUS_CACHE_HIT
SQLITE_DBSTATUS_CACHE_MISS
SQLITE_DBSTATUS_CACHE_SPILL
SQLITE_DBSTATUS_CACHE_USED
SQLITE_DBSTATUS_CACHE_USED_SHARED
SQLITE_DBSTATUS_CACHE_WRITE
SQLITE_DBSTATUS_DEFERRED_FKS
SQLITE_DBSTATUS_LOOKASIDE_HIT
SQLITE_DBSTATUS_LOOKASIDE_MISS_FULL
SQLITE_DBSTATUS_LOOKASIDE_MISS_SIZE
SQLITE_DBSTATUS_LOOKASIDE_USED
SQLITE_DBSTATUS_MAX
SQLITE_DBSTATUS_SCHEMA_USED
SQLITE_DBSTATUS_STMT_USED
SQLITE_DELETE
SQLITE_DENY
SQLITE_DESERIALIZE_FREEONCLOSE
SQLITE_DESERIALIZE_READONLY
SQLITE_DESERIALIZE_RESIZEABLE
SQLITE_DETACH
SQLITE_DETERMINISTIC
SQLITE_DIRECTONLY
SQLITE_DONE
SQLITE_DROP_INDEX
SQLITE_DROP_TABLE
SQLITE_DROP_TEMP_INDEX
SQLITE_DROP_TEMP_TABLE
SQLITE_DROP_TEMP_TRIGGER
SQLITE_DROP_TEMP_VIEW
SQLITE_DROP_TRIGGER
SQLITE_DROP_VIEW
SQLITE_DROP_VTABLE
SQLITE_EMPTY
SQLITE_ERROR
SQLITE_ERROR_MISSING_COLLSEQ
SQLITE_ERROR_RETRY
SQLITE_ERROR_SNAPSHOT
SQLITE_FAIL
SQLITE_FCNTL_BEGIN_ATOMIC_WRITE
SQLITE_FCNTL_BUSYHANDLER
SQLITE_FCNTL_CHUNK_SIZE
SQLITE_FCNTL_CKPT_DONE
SQLITE_FCNTL_CKPT_START
SQLITE_FCNTL_CKSM_FILE
SQLITE_FCNTL_COMMIT_ATOMIC_WRITE
SQLITE_FCNTL_COMMIT_PHASETWO
SQLITE_FCNTL_DATA_VERSION
SQLITE_FCNTL_EXTERNAL_READER
SQLITE_FCNTL_FILE_POINTER
SQLITE_FCNTL_GET_LOCKPROXYFILE
SQLITE_FCNTL_HAS_MOVED
SQLITE_FCNTL_JOURNAL_POINTER
SQLITE_FCNTL_LAST_ERRNO
SQLITE_FCNTL_LOCKSTATE
SQLITE_FCNTL_LOCK_TIMEOUT
SQLITE_FCNTL_MMAP_SIZE
SQLITE_FCNTL_OVERWRITE
SQLITE_FCNTL_PDB
SQLITE_FCNTL_PERSIST_WAL
SQLITE_FCNTL_POWERSAFE_OVERWRITE
SQLITE_FCNTL_PRAGMA
SQLITE_FCNTL_RBU
SQLITE_FCNTL_RESERVE_BYTES
SQLITE_FCNTL_RESET_CACHE
SQLITE_FCNTL_ROLLBACK_ATOMIC_WRITE
SQLITE_FCNTL_SET_LOCKPROXYFILE
SQLITE_FCNTL_SIZE_HINT
SQLITE_FCNTL_SIZE_LIMIT
SQLITE_FCNTL_SYNC
SQLITE_FCNTL_SYNC_OMITTED
SQLITE_FCNTL_TEMPFILENAME
SQLITE_FCNTL_TRACE
SQLITE_FCNTL_VFSNAME
SQLITE_FCNTL_VFS_POINTER
SQLITE_FCNTL_WAL_BLOCK
SQLITE_FCNTL_WIN32_AV_RETRY
SQLITE_FCNTL_WIN32_GET_HANDLE
SQLITE_FCNTL_WIN32_SET_HANDLE
SQLITE_FCNTL_ZIPVFS
SQLITE_FLOAT
SQLITE_FORMAT
SQLITE_FULL
SQLITE_FUNCTION
SQLITE_IGNORE
SQLITE_INDEX_CONSTRAINT_EQ
SQLITE_INDEX_CONSTRAINT_FUNCTION
SQLITE_INDEX_CONSTRAINT_GE
SQLITE_INDEX_CONSTRAINT_GLOB
SQLITE_INDEX_CONSTRAINT_GT
SQLITE_INDEX_CONSTRAINT_IS
SQLITE_INDEX_CONSTRAINT_ISNOT
SQLITE_INDEX_CONSTRAINT_ISNOTNULL
SQLITE_INDEX_CONSTRAINT_ISNULL
SQLITE_INDEX_CONSTRAINT_LE
SQLITE_INDEX_CONSTRAINT_LIKE
SQLITE_INDEX_CONSTRAINT_LIMIT
SQLITE_INDEX_CONSTRAINT_LT
SQLITE_INDEX_CONSTRAINT_MATCH
SQLITE_INDEX_CONSTRAINT_NE
SQLITE_INDEX_CONSTRAINT_OFFSET
SQLITE_INDEX_CONSTRAINT_REGEXP
SQLITE_INDEX_SCAN_HEX
SQLITE_INDEX_SCAN_UNIQUE
SQLITE_INNOCUOUS
SQLITE_INSERT
SQLITE_INTEGER
SQLITE_INTERNAL
SQLITE_INTERRUPT
SQLITE_IOCAP_ATOMIC
SQLITE_IOCAP_ATOMIC16K
SQLITE_IOCAP_ATOMIC1K
SQLITE_IOCAP_ATOMIC2K
SQLITE_IOCAP_ATOMIC32K
SQLITE_IOCAP_ATOMIC4K
SQLITE_IOCAP_ATOMIC512
SQLITE_IOCAP_ATOMIC64K
SQLITE_IOCAP_ATOMIC8K
SQLITE_IOCAP_BATCH_ATOMIC
SQLITE_IOCAP_IMMUTABLE
SQLITE_IOCAP_POWERSAFE_OVERWRITE
SQLITE_IOCAP_SAFE_APPEND
SQLITE_IOCAP_SEQUENTIAL
SQLITE_IOCAP_SUBPAGE_READ
SQLITE_IOCAP_UNDELETABLE_WHEN_OPEN
SQLITE_IOERR
SQLITE_IOERR_ACCESS
SQLITE_IOERR_AUTH
SQLITE_IOERR_BEGIN_ATOMIC
SQLITE_IOERR_BLOCKED
SQLITE_IOERR_CHECKRESERVEDLOCK
SQLITE_IOERR_CLOSE
SQLITE_IOERR_COMMIT_ATOMIC
SQLITE_IOERR_CONVPATH
SQLITE_IOERR_CORRUPTFS
SQLITE_IOERR_DATA
SQLITE_IOERR_DELETE
SQLITE_IOERR_DELETE_NOENT
SQLITE_IOERR_DIR_CLOSE
SQLITE_IOERR_DIR_FSYNC
SQLITE_IOERR_FSTAT
SQLITE_IOERR_FSYNC
SQLITE_IOERR_GETTEMPPATH
SQLITE_IOERR_IN_PAGE
SQLITE_IOERR_LOCK
SQLITE_IOERR_MMAP
SQLITE_IOERR_NOMEM
SQLITE_IOERR_RDLOCK
SQLITE_IOERR_READ
SQLITE_IOERR_ROLLBACK_ATOMIC
SQLITE_IOERR_SEEK
SQLITE_IOERR_SHMLOCK
SQLITE_IOERR_SHMMAP
SQLITE_IOERR_SHMOPEN
SQLITE_IOERR_SHMSIZE
SQLITE_IOERR_SHORT_READ
SQLITE_IOERR_TRUNCATE
SQLITE_IOERR_UNLOCK
SQLITE_IOERR_VNODE
SQLITE_IOERR_WRITE
SQLITE_LIMIT_ATTACHED
SQLITE_LIMIT_COLUMN
SQLITE_LIMIT_COMPOUND_SELECT
SQLITE_LIMIT_EXPR_DEPTH
SQLITE_LIMIT_FUNCTION_ARG
SQLITE_LIMIT_LENGTH
SQLITE_LIMIT_LIKE_PATTERN_LENGTH
SQLITE_LIMIT_SQL_LENGTH
SQLITE_LIMIT_TRIGGER_DEPTH
SQLITE_LIMIT_VARIABLE_NUMBER
SQLITE_LIMIT_VDBE_OP
SQLITE_LIMIT_WORKER_THREADS
SQLITE_LOCKED
SQLITE_LOCKED_SHAREDCACHE
SQLITE_LOCKED_VTAB
SQLITE_LOCK_EXCLUSIVE
SQLITE_LOCK_NONE
SQLITE_LOCK_PENDING
SQLITE_LOCK_RESERVED
SQLITE_LOCK_SHARED
SQLITE_MISMATCH
SQLITE_MISUSE
SQLITE_MUTEX_FAST
SQLITE_MUTEX_RECURSIVE
SQLITE_MUTEX_STATIC_APP1
SQLITE_MUTEX_STATIC_APP2
SQLITE_MUTEX_STATIC_APP3
SQLITE_MUTEX_STATIC_LRU
SQLITE_MUTEX_STATIC_LRU2
SQLITE_MUTEX_STATIC_MAIN
SQLITE_MUTEX_STATIC_MEM
SQLITE_MUTEX_STATIC_MEM2
SQLITE_MUTEX_STATIC_OPEN
SQLITE_MUTEX_STATIC_PMEM
SQLITE_MUTEX_STATIC_PRNG
SQLITE_MUTEX_STATIC_VFS1
SQLITE_MUTEX_STATIC_VFS2
SQLITE_MUTEX_STATIC_VFS3
SQLITE_NOLFS
SQLITE_NOMEM
SQLITE_NOTADB
SQLITE_NOTFOUND
SQLITE_NOTICE
SQLITE_NOTICE_RBU
SQLITE_NOTICE_RECOVER_ROLLBACK
SQLITE_NOTICE_RECOVER_WAL
SQLITE_NULL
SQLITE_OK
SQLITE_OK_LOAD_PERMANENTLY
SQLITE_OK_SYMLINK
SQLITE_OPEN_AUTOPROXY
SQLITE_OPEN_CREATE
SQLITE_OPEN_DELETEONCLOSE
SQLITE_OPEN_EXCLUSIVE
SQLITE_OPEN_EXRESCODE
SQLITE_OPEN_FULLMUTEX
SQLITE_OPEN_MAIN_DB
SQLITE_OPEN_MAIN_JOURNAL
SQLITE_OPEN_MEMORY
SQLITE_OPEN_NOFOLLOW
SQLITE_OPEN_NOMUTEX
SQLITE_OPEN_PRIVATECACHE
SQLITE_OPEN_READONLY
SQLITE_OPEN_READWRITE
SQLITE_OPEN_SHAREDCACHE
SQLITE_OPEN_SUBJOURNAL
SQLITE_OPEN_SUPER_JOURNAL
SQLITE_OPEN_TEMP_DB
SQLITE_OPEN_TEMP_JOURNAL
SQLITE_OPEN_TRANSIENT_DB
SQLITE_OPEN_URI
SQLITE_OPEN_WAL
SQLITE_PERM
SQLITE_PRAGMA
SQLITE_PREPARE_NORMALIZE
SQLITE_PREPARE_NO_VTAB
SQLITE_PREPARE_PERSISTENT
SQLITE_PROTOCOL
SQLITE_RANGE
SQLITE_READ
SQLITE_READONLY
SQLITE_READONLY_CANTINIT
SQLITE_READONLY_CANTLOCK
SQLITE_READONLY_DBMOVED
SQLITE_READONLY_DIRECTORY
SQLITE_READONLY_RECOVERY
SQLITE_READONLY_ROLLBACK
SQLITE_RECURSIVE
SQLITE_REINDEX
SQLITE_REPLACE
SQLITE_RESULT_SUBTYPE
SQLITE_ROLLBACK
SQLITE_ROW
SQLITE_SAVEPOINT
SQLITE_SCANSTAT_COMPLEX
SQLITE_SCANSTAT_EST
SQLITE_SCANSTAT_EXPLAIN
SQLITE_SCANSTAT_NAME
SQLITE_SCANSTAT_NCYCLE
SQLITE_SCANSTAT_NLOOP
SQLITE_SCANSTAT_NVISIT
SQLITE_SCANSTAT_PARENTID
SQLITE_SCANSTAT_SELECTID
SQLITE_SCHEMA
SQLITE_SELECT
SQLITE_SELFORDER1
SQLITE_SERIALIZE_NOCOPY
SQLITE_SHM_EXCLUSIVE
SQLITE_SHM_LOCK
SQLITE_SHM_NLOCK
SQLITE_SHM_SHARED
SQLITE_SHM_UNLOCK
SQLITE_SOURCE_ID
SQLITE_STATIC
SQLITE_STATUS_MALLOC_COUNT
SQLITE_STATUS_MALLOC_SIZE
SQLITE_STATUS_MEMORY_USED
SQLITE_STATUS_PAGECACHE_OVERFLOW
SQLITE_STATUS_PAGECACHE_SIZE
SQLITE_STATUS_PAGECACHE_USED
SQLITE_STATUS_PARSER_STACK
SQLITE_STATUS_SCRATCH_OVERFLOW
SQLITE_STATUS_SCRATCH_SIZE
SQLITE_STATUS_SCRATCH_USED
SQLITE_STMTSTATUS_AUTOINDEX
SQLITE_STMTSTATUS_FILTER_HIT
SQLITE_STMTSTATUS_FILTER_MISS
SQLITE_STMTSTATUS_FULLSCAN_STEP
SQLITE_STMTSTATUS_MEMUSED
SQLITE_STMTSTATUS_REPREPARE
SQLITE_STMTSTATUS_RUN
SQLITE_STMTSTATUS_SORT
SQLITE_STMTSTATUS_VM_STEP
SQLITE_SUBTYPE
SQLITE_SYNC_DATAONLY
SQLITE_SYNC_FULL
SQLITE_SYNC_NORMAL
SQLITE_TESTCTRL_ALWAYS
SQLITE_TESTCTRL_ASSERT
SQLITE_TESTCTRL_BENIGN_MALLOC_HOOKS
SQLITE_TESTCTRL_BITVEC_TEST
SQLITE_TESTCTRL_BYTEORDER
SQLITE_TESTCTRL_EXPLAIN_STMT
SQLITE_TESTCTRL_EXTRA_SCHEMA_CHECKS
SQLITE_TESTCTRL_FAULT_INSTALL
SQLITE_TESTCTRL_FIRST
SQLITE_TESTCTRL_FK_NO_ACTION
SQLITE_TESTCTRL_GETOPT
SQLITE_TESTCTRL_IMPOSTER
SQLITE_TESTCTRL_INTERNAL_FUNCTIONS
SQLITE_TESTCTRL_ISINIT
SQLITE_TESTCTRL_ISKEYWORD
SQLITE_TESTCTRL_JSON_SELFCHECK
SQLITE_TESTCTRL_LAST
SQLITE_TESTCTRL_LOCALTIME_FAULT
SQLITE_TESTCTRL_LOGEST
SQLITE_TESTCTRL_NEVER_CORRUPT
SQLITE_TESTCTRL_ONCE_RESET_THRESHOLD
SQLITE_TESTCTRL_OPTIMIZATIONS
SQLITE_TESTCTRL_PARSER_COVERAGE
SQLITE_TESTCTRL_PENDING_BYTE
SQLITE_TESTCTRL_PRNG_RESET
SQLITE_TESTCTRL_PRNG_RESTORE
SQLITE_TESTCTRL_PRNG_SAVE
SQLITE_TESTCTRL_PRNG_SEED
SQLITE_TESTCTRL_RESERVE
SQLITE_TESTCTRL_RESULT_INTREAL
SQLITE_TESTCTRL_SCRATCHMALLOC
SQLITE_TESTCTRL_SEEK_COUNT
SQLITE_TESTCTRL_SORTER_MMAP
SQLITE_TESTCTRL_TRACEFLAGS
SQLITE_TESTCTRL_TUNE
SQLITE_TESTCTRL_USELONGDOUBLE
SQLITE_TESTCTRL_VDBE_COVERAGE
SQLITE_TEXT
SQLITE_TOOBIG
SQLITE_TRACE
SQLITE_TRACE_CLOSE
SQLITE_TRACE_PROFILE
SQLITE_TRACE_ROW
SQLITE_TRACE_STMT
SQLITE_TRANSACTION
SQLITE_TRANSIENT
SQLITE_TXN_NONE
SQLITE_TXN_READ
SQLITE_TXN_WRITE
SQLITE_UPDATE
SQLITE_UTF16
SQLITE_UTF16BE
SQLITE_UTF16LE
SQLITE_UTF16_ALIGNED
SQLITE_UTF8
SQLITE_VERSION
SQLITE_VERSION_NUMBER
SQLITE_VTAB_CONSTRAINT_SUPPORT
SQLITE_VTAB_DIRECTONLY
SQLITE_VTAB_INNOCUOUS
SQLITE_VTAB_USES_ALL_SCHEMAS
SQLITE_WARNING
SQLITE_WARNING_AUTOINDEX
SQLITE_WIN32_DATA_DIRECTORY_TYPE
SQLITE_WIN32_TEMP_DIRECTORY_TYPE
Other lists:
Objects
and
Functions
and
Result Codes
.