application_id |
Queries or sets the 32-bit unsigned big-endianApplication IDinteger. Consult
the SQLite application_id
documentation for complete details.
- Novalueargument returns: single value.
- Withvalueargument returns: result code.
- value:integer
|
auto_vacum |
Queries or sets the auto-vacuum status in the database. Consult the SQLite auto_vacum documentation for complete
details.
- Novalueargument returns: single value.
- Withvalueargument returns: result code.
- value:0 ¦ NONE ¦ 1 ¦ FULL ¦ 2 ¦ INCREMENTA
|
automatic_index |
Queries, sets, or clears the automatic indexing capability. Consult the SQLite automatic_index documentation for
complete details.
- Novalueargument returns: single value.
- Withvalueargument returns: result code.
- value:true ¦ false
|
busy_timeout |
Queries or changes the setting of the busyTimeOut timeout. This pragma is an
alternative to thebusyTimeOutmethod. SQLite makes the pragma available as a
pragma for use with language bindings that do not provide direct access to the sqlite3_busy_timeout() API.
ooSQLite of course does provide direct access through both thebusyTimeOut
method and the oosqlBusyTimeOut routine. The pragma is included here
for completeness. Consult the SQLite busy_timeout documentation for complete
details.
- Novalueargument returns: single value.
- Withvalueargument returns: single value.
- value:milliseconds
|
cache_size |
Queries or changes the suggested maximum number of database disk pages that SQLite will hold in memory at once
per open database file. Consult the SQLite cache_size documentation for complete details.
- Novalueargument returns: single value.
- Withvalueargument returns: result code.
- value:pages ¦ -kibibytes
|
cache_spill |
Enables or disables the ability of the pager to spill dirty cache pages to the database file in the middle of a
transaction. Cache_spill is enabled by default and most applications should leave it that way as cache spilling
is usually advantageous. Consult the SQLite cache_spill documentation for complete
details.
- Novalueargument returns: single value.
- Withvalueargument returns: result code.
- value:true or false
|
case_sensitive_like |
Installs a new application-defined LIKE function that is either case sensitive or insensitive depending on the
value of the case_sensitive_like pragma. By default LIKE is case-insensitive. Consult the SQLite case_sensitive_like documentation for
complete details.
- Novalueargument: invalid, condition raised.
- Withvalueargument: single value
- value:true or false
|
checkpoint_fullfsync |
Query or change the fullfsync flag for checkpoint operations. Consult the SQLite checkpoint_fullfsync documentation
for complete details.
- Novalueargument returns: single value.
- Withvalueargument returns: result code.
- value:true or false
|
collation_list |
Returns a list of the collating sequences defined for the current database connection. Consult the SQLite collation_list documentation for complete
details.
- Novalueargument returns: result set.
- Withvalueargument: invalid, condition raised
- value:invalid
|
compile_options |
Returns the names of compile-time options used when building SQLite, one option per row. TheSQLITE_prefix is omitted from the returned option names. Consult the SQLite compile_options documentation for complete
details.
- Novalueargument returns: result set.
- Withvalueargument: invalid, condition raised
- value:invalid
|
database_list |
Works like a query to return one row for each database attached to the current database connection. Consult the
SQLite database_list documentation
for complete details.
- Novalueargument returns: result set.
- Withvalueargument: invalid, condition raised
- value:invalid
|
defer_foreign_keys |
When the defer_foreign_keys PRAGMA is on, enforcement of all foreign key constraints is delayed until the
outermost transaction is committed. The defer_foreign_keys pragma defaults to OFF so that foreign key constraints
are only deferred if they are created as "DEFERRABLE INITIALLY DEFERRED". This pragma is only meaningful if
foreign key constraints are enabled, of course. Consult the SQLite database_list documentation for complete
details.
- Novalueargument returns: single value.
- Withvalueargument returns: result code.
- value:true or false
|
encoding |
When used as a query, if the main database has already been created, then this pragma returns the text encoding
used by the main database, one of "UTF-8", "UTF-16le" (little-endian UTF-16 encoding) or "UTF-16be" (big-endian
UTF-16 encoding). If the main database has not already been created, then the value returned is the text encoding
that will be used to create the main database, if it is created by this session. Consult the SQLite encoding documentation for complete details.
- Novalueargument returns: single value.
- Withvalueargument returns: result code.
- value:UTF-8 ¦ UTF-16 ¦ UTF-16le ¦ UTF-16be
|
foreign_key_check |
Checks the database, or the table specified, for foreign key constraints that are violated and returns one row of
output for each violation. Consult the SQLite foreign_key_check documentation for
complete details.
- Novalueargument returns: result set.
- Withvalueargument returns: result set.
- value:table_name, not required
|
foreign_key_list |
Returns one row for each foreign key that references a column in the argumenttable. Consult the SQLite foreign_key_list documentation for
complete details.
- Novalueargument: invalid, condition raised.
- Withvalueargument returns: result set.
- value:table_name
|
foreign_keys |
Query, set, or clear the enforcement of foreign key constraints. Consult the SQLite foreign_keys documentation for complete
details.
- Novalueargument returns: single value.
- Withvalueargument returns: result code.
- value:true or false
|
freelist_count |
Returns the number of unused pages in the database file. Consult the SQLite freelist_count documentation for complete
details.
- Novalueargument returns: single value.
- Withvalueargument: invalid, condition raised.
- value:invalid
|
fullfsync |
Query or change the fullfsync flag. Consult the SQLite fullfsync documentation for complete details.
- Novalueargument returns: single value.
- Withvalueargument returns: result code.
- value:true or false
|
ignore_check_constraints |
Enables or disables the enforcement of CHECK constraints. The default setting is off, meaning that CHECK
constraints are enforced by default. Consult the SQLite ignore_check_constraints
documentation for complete details.
- Novalueargument returns: single value.
- Withvalueargument returns: result code.
- value:true or false
|
incremental_vacuum |
Causes up to N pages to be removed from the freelist. The database file is truncated by the same amount. If
there are fewer than N pages on the freelist, N is omitted, or N is less than 1, all pages are removed. Consult
the SQLite incremental_vacuum
documentation for complete details.
- Novalueargument returns: result code.
- Withvalueargument returns: result code.
- value:N, not required
|
index_info |
Returns one row each column in the named index. The first column of the result is the rank of the column within
the index. The second column of the result is the rank of the column within the table. The third column of output
is the name of the column being indexed. Consult the SQLite index_info documentation for complete details.
- Novalueargument: invalid, condition raised.
- Withvalueargument returns: result set
- value:index_name, required
|
index_list |
Returns one row for each index associated with the given table. Columns of the result set include the index name
and a flag to indicate whether or not the index is UNIQUE. Consult the SQLite index_list documentation for complete details.
- Novalueargument: invalid, condition raised.
- Withvalueargument returns: result set
- value:table_name, required
|
integrity_check |
Does an integrity check of the entire database. It looks for out-of-order records, missing pages, malformed
records, and corrupt indices. If any problems are found, then strings are returned (as multiple rows with a
single column per row) which describe the problems. At most N errors will be reported before the analysis
quits. The default value for N is 100. If no errors are found, a single row with the valueokis returned. Consult the SQLite integrity_check documentation for complete
details.
- Novalueargument returns: result set.
- Withvalueargument returns: result set.
- value:N, not required
|
journal_mode |
Queries or sets the journal mode for databases associated with the current database connection. Consult the
SQLite journal_mode documentation for
complete details.
- Novalueargument returns: single value.
- Withvalueargument returns: single value
- value:DELETE ¦ TRUNCATE ¦ PERSIST ¦ MEMORY ¦ WAL ¦ OFF
|
journal_size_limit |
This pragma can be used to limit the size (N bytes) of rollback-journal and WAL files left in the file-system
after transactions or checkpoints. Consult the SQLite journal_size_limit documentation for
complete details.
- Novalueargument returns: single value.
- Withvalueargument returns: single value.
- value:N or -1, no limit
|
legacy_file_format |
Sets or queries the value of the legacy_file_format flag. When this flag is on, new SQLite databases are created
in a file format that is readable and writable by all versions of SQLite going back to 3.0.0. When the flag is
off, new databases are created using the latest file format which might not be readable or writable by versions
of SQLite prior to 3.3.0. Consult the SQLite legacy_file_format documentation for
complete details.
- Novalueargument returns: single value.
- Withvalueargument returns: result code.
- value:true or false
|
locking_mode |
Sets or queries the database connection locking-mode. The locking-mode is either NORMAL or EXCLUSIVE. Consult the
SQLite locking_mode documentation for
complete details.
- Novalueargument returns: single value.
- Withvalueargument returns: result code.
- value:NORMAL ¦ EXCLUSIVE
|
max_page_count |
Queries or set the maximum number of pages (N) in the database file. Both forms of the pragma return the maximum
page count. The set form attempts to modify the maximum page count. The maximum page count cannot be reduced
below the current database size. Consult the SQLite max_page_count documentation for complete
details.
- Novalueargument returns: single value.
- Withvalueargument returns: single value.
- value:N
|
mmap_size |
Query or change the maximum number of bytes (N) that are set aside for memory-mapped I/O on a single database.
Consult the SQLite page_count
documentation for complete details.
- Novalueargument returns: single value.
- Withvalueargument returns: result code.
- value:N
|
page_count |
Returns the total number of pages in the database file. Consult the SQLite page_count documentation for complete details.
- Novalueargument returns: single value.
- Withvalueargument returns: invalid, condition raised.
- value:invalid
|
page_size |
Queries or sets the page size (N) of the database. The page size must be a power of two between 512 and 65536
inclusive. Consult the SQLite page_size
documentation for complete details.
- Novalueargument returns: single value.
- Withvalueargument returns: result code.
- value:N
|
query_only |
Prevents all changes to database files when enabled. Consult the SQLite query_only documentation for complete details.
- Novalueargument returns: single value.
- Withvalueargument returns: result code.
- value:true or false
|
quick_check |
Performs an integrity check, like the integrity_check pragma, except that it does not verify that index content
matches table content. By skipping the verification of index content, quick_check is able to run much faster than
integrity_check. At most N errors will be reported before the analysis quits. The default value for N is 100. If
no errors are found, a single row with the valueokis returned. Otherwise the
two pragmas are the same. Consult the SQLite quick_check documentation for complete
details.
- Novalueargument returns: result set.
- Withvalueargument returns: result set.
- value:N, not required
|
read_uncommitted |
Query, set, or clear READ UNCOMMITTED isolation. Consult the SQLite read_uncommitted documentation for
complete details.
- Novalueargument returns: single value.
- Withvalueargument returns: result code.
- value:true or false
|
recursive_triggers |
Query, set, or clear the recursive trigger capability. Consult the SQLite recursive_triggers documentation for
complete details.
- Novalueargument returns: single value.
- Withvalueargument returns: result code.
- value:true or false
|
reverse_unordered_selects |
When enabled, this pragma causes SELECT statements without an ORDER BY clause to emit their results in the
reverse order of what they normally would. This can help debug applications that are making invalid assumptions
about the result order. Consult the SQLite reverse_unordered_selects
documentation for complete details.
- Novalueargument returns: single value.
- Withvalueargument returns: result code.
- value:true or false
|
schema_version |
Used to set or get the value of the schema-version. The pragmas schema_version and user_version are used to set
or get the value of the schema-version and user-version, respectively. The schema-version and the user-version
are big-endian 32-bit signed integers stored in the database header.
The schema-version is usually only manipulated internally by SQLite. Using the schema_version pragma to modify
the schema-version is potentially dangerous and may lead to program crashes or database corruption. Use with
caution.
The user-version is not used internally by SQLite. It may be used by applications for any purpose. Consult the
SQLite schema_version documentation
for complete details.
- Novalueargument returns: single value.
- Withvalueargument returns: result code.
- value:32-bit integer
|
secure_delete |
Queries or changes the secure-delete setting. When secure-delete on, SQLite overwrites deleted content with
zeros. Consult the SQLite secure_delete documentation for complete
details.
- Novalueargument returns: single value.
- Withvalueargument returns: single value.
- value:true or false
|
shrink_memory |
Causes the database connection on which it is invoked to free up as much memory as it can. Consult the SQLite
shrink_memory documentation for
complete details.
- Novalueargument returns: result code.
- Withvalueargument: invalid, condition raised
- value:invalid
|
soft_heap_limit |
This pragma invokes the softHeapLimit64 method with the argument N,
if N is specified and is a non-negative integer. The soft_heap_limit pragma always returns the same integer that
would be returned by thesoftHeapLimit64method with an argument of -1.
C-language function. Consult the SQLite shrink_memory documentation for complete
details.
- Novalueargument returns: single value.
- Withvalueargument returns: single value
- value:N
|
synchronous |
Queries or changes the setting of the "synchronous" flag. Consult the SQLite synchronous documentation for complete
details.
- Novalueargument returns: single value.
- Withvalueargument returns: result code.
- value:0 ¦ OFF ¦ 1 ¦ NORMAL ¦ 2 ¦ FULL
|
table_info |
Returns a row for each column in the named table. Columns in the result set include the column name, data type,
whether or not the column can be NULL, and the default value for the column. Consult the SQLite table_info documentation for complete details.
- Novalueargument: invalid, condtion raised
- Withvalueargument returns: result set.
- value:table_name, required
|
temp_store |
Queries or changes the setting of thetemp_storeparameter. Consult the SQLite
temp_store documentation for complete
details.
- Novalueargument returns: single value.
- Withvalueargument returns: result code.
- value:0 ¦ DEFAULT ¦ 1 ¦ FILE ¦ 2 ¦ MEMORY
|
user_version |
Used to set or get the value of the user-version. The pragmas schema_version and user_version are used to set or
get the value of the schema-version and user-version, respectively. The schema-version and the user-version are
big-endian 32-bit signed integers stored in the database header.
The schema-version is usually only manipulated internally by SQLite. Using the schema_version pragma to modify
the schema-version is potentially dangerous and may lead to program crashes or database corruption. Use with
caution.
The user-version is not used internally by SQLite. It may be used by applications for any purpose. Consult the
SQLite schema_version documentation
for complete details.
- Novalueargument returns: single value.
- Withvalueargument returns: result code.
- value:32-bit integer
|
wal_autocheckpoint |
Queries or sets the write-ahead log auto-checkpoint interval. When the write-ahead log is enabled (via the
journal_mode pragma) a checkpoint will be run automatically whenever the write-ahead log equals or exceeds N
pages in length. Setting the auto-checkpoint size (N) to zero or a negative value turns auto-checkpointing
off.Consult the SQLite wal_autocheckpoint documentation for
complete details.
- Novalueargument returns: single value.
- Withvalueargument returns: single value.
- value:N
|
wal_checkpoint |
If the write-ahead log is enabled (via the journal_mode pragma), this pragma causes a checkpoint operation to run
on the nameddatabasedatabase, or on all attached databases ifdatabaseis omitted. If write-ahead log mode is disabled, this pragma is a harmless
no-op. Consult the SQLite wal_checkpoint documentation for complete
details.
- Novalueargument returns: result set.
- Withvalueargument returns: result set.
- value:PASSIVE ¦ FULL ¦ RESTART
|
writable_schema |
When this pragma is on, the SQLITE_MASTER tables in the database can be changed using ordinary UPDATE, INSERT,
and DELETE statements. Warning: misuse of this pragma can easily result in a corrupt database file. Consult the
SQLite writable_schema
documentation for complete details.
- Novalueargument returns: singel value.
- Withvalueargument returns: result code.
- value:true or false
|