Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Unlock-Notify API
(unlock_notify.html)
... Re-attempting the "DROP
TABLE" or "DROP INDEX" statement will return another SQLITE_LOCKED
error. In the implementation of sqlite3_blocking_step() shown to the
left, this could cause an infinite loop.
The caller could distinguish between this special "DROP TABLE|INDEX"
case ...
|
|
SQLite Database Speed Comparison
(speed.html)
... DROP TABLE
DROP TABLE t1;DROP TABLE t2;DROP TABLE t3;
PostgreSQL: 0.135
MySQL: 0.015
SQLite 2.7.6: 0.939
SQLite 2.7.6 (nosync): ...
|
|
CREATE TRIGGER
(lang_createtrigger.html)
... Triggers are automatically dropped
when the table that they are
associated with (the table-name table) is
dropped. However if the trigger actions reference
other tables, the trigger is not dropped or modified if those other
tables are dropped or ...
|
|
C API: Compare the ages of two snapshot handles.
(c3ref/snapshot_cmp.html)
sqlite3_snapshot_cmp()
... The wal file is deleted when the
database is changed back to rollback mode or when the number of database
clients drops to zero. If either snapshot handle was obtained before the
wal file was last deleted, the value returned ...
|
|
Automatic Undo/Redo With SQLite
(undoredo.html)
... Remember that the code here is a demonstration of the technique,
not a drop-in module that will automatically do everything for you.
The demonstration code shown below is derived from actual code
in production use. But you will need ...
|
|
C API: Register A Virtual Table Implementation
(c3ref/create_module.html)
sqlite3_create_module(), sqlite3_create_module_v2()
... If the third parameter (the pointer to the sqlite3_module object) is
NULL then no new module is created and any existing modules with the
same name are dropped.
See also: sqlite3_drop_modules()
See also lists of
Objects,
Constants, and
Functions.
|
|
SQLite Pro Support
(prosupport.html)
... A drop-in replacement for public-domain SQLite C source code that has
the added ability to read/write AES-encrypted databases.
$2000 one time fee
More Info
Purchase
7.SQLite Encryption Extension (SEE) for System.Data.SQLite.
A license ...
|
|
SQL Features That SQLite Does Not Implement
(omitted.html)
... Complete ALTER TABLE support
Only the RENAME TABLE, ADD COLUMN, RENAME COLUMN, and DROP COLUMN
variants of the ALTER TABLE command are supported. Other kinds of
ALTER TABLE operations such as
ALTER COLUMN, ADD CONSTRAINT, and so forth are ...
|
|
Syntax Diagrams For SQLite
(syntaxdiagrams.html)
... Used by: sql-stmt
See also: lang_detach.html
drop-index-stmt:
Used by: sql-stmt
See also: lang_dropindex.html
drop-table-stmt:
Used by: sql-stmt
See also: ...
|
|
SQLite Foreign Key Support
(foreignkeys.html)
5. CREATE, ALTER and DROP TABLE commands
This section describes the way the CREATE TABLE, ALTER TABLE,
and DROP TABLE commands
interact with SQLite's foreign keys.
A CREATE TABLE command operates the same whether or not
foreign key constraints are enabled. The parent key definitions of ...
|
Page generated by FTS5 in about 49.83 ms.