List Of SQLite Constants
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_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_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_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_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_IMPOSTER
- SQLITE_TESTCTRL_INTERNAL_FUNCTIONS
- SQLITE_TESTCTRL_ISINIT
- SQLITE_TESTCTRL_ISKEYWORD
- 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.
SQLite is in the Public Domain.
https://sqlite.org/c3ref/constlist.html