SQL As Understood By SQLite

[Top]

ATTACH DATABASE

attach-stmt:

The ATTACH DATABASE statement adds another database file to the current database connection. The filename for the database to be attached is the value of the expression that occurs before the AS keyword. The filename of the database follows the same semantics as the filename argument to sqlite3_open() and sqlite3_open_v2(); the special name ":memory:" results in an in-memory database and an empty string results in a new temporary database. The filename argument can be a URI filename if URI filename processing is enable on the database connection. The default behavior is for URI filenames to be disabled, however that might change in a future release c.html#defauote>

SQLITE_OMIT_MERGE_SORT

Beginning with SQLite version 3.7.8, large sort operations such as used by CREATE INDEX commands are implemented using an external merge sort rather than insertions into a B-Tree. This results in better cache locality and an order-of-magnitude speed improvement for sorts that are larger than the filesystem cache. On the other hand, the merge sort logic uses some code space and is slightly (1%) slower for CREATE INDEX on small tables. The external merge sort can be disabled using this compile-time option.

SQLITE_OMIT_OR_OPTIMIZATION

This option disables the ability of SQLite to use an index together with terms of a WHERE clause connected by the OR operator.

SQLITE_OMIT_PAGER_PRAGMAS

Defining this option omits pragmas related to the pager subsystem from the build.

SQLITE_OMIT_PRAGMA

This option is used to omit the PRAGMA command from the library. Note that it is useful to define the macros that omit specific pragmas in addition to this, as they may also remove supporting code in other sub-systems. This macro removes the PRAGMA command only.

SQLITE_OMIT_PROGRESS_CALLBACK