1.2. Example Output  ... Number of tables in the database The number of tables in the database, including the SQLITE_SCHEMA table used to store schema information. Number of indices The total number of indices in the database. Number of defined indices The number of ... 

 ... 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 ... 

5. Querying the database schema  ... For example, to see a list of the tables in the database, you can enter ".tables". sqlite> .tables tbl1 tbl2 sqlite> The ".tables" command is similar to setting list mode then executing the following query: SELECT name FROM ... 

sqlite3_stmt_status()

 ... For example, if the number of table steps greatly exceeds the number of table searches or result rows, that would tend to indicate that the prepared statement is using a full table scan rather than an index. This interface is ... 

sqlite3_update_hook()

The sqlite3_update_hook() interface registers a callback function with the database connection identified by the first argument to be invoked whenever a row is updated, inserted or deleted in a rowid table. Any callback set by a previous call to this ... 

 ... Once removed, the trigger definition is no longer present in the sqlite_schema (or sqlite_temp_schema) table and is not fired by any subsequent INSERT, UPDATE or DELETE statements. Note that triggers are automatically dropped when the associated table is dropped.

 ... Before writing to a table, a write (exclusive) lock must be obtained on that table. Before reading, a read (shared) lock must be obtained. A connection releases all held table locks when it concludes its transaction. If a connection cannot ... 

2. Simple Cases - Rows, Loops and Cycles  ... CREATE VIRTUAL TABLE ft USING fts5(text); CREATE TABLE t1(a, b); CREATE TABLE t2(c INTEGER PRIMARY KEY, d); Then, after first executing ".scanstats on": sqlite3> SELECT * FROM t1, t2 WHERE t2.c=t1.a; <...query results...> ... 

 ... For example, suppose you wanted undo/redo on a class (table) that looks like this: CREATE TABLE ex1(a,b,c); Triggers to record changes to table EX1 might look like this: CREATE TEMP TRIGGER ex1_it AFTER INSERT ON ex1 ... 

sqlite3_column_decltype(), sqlite3_column_decltype16()

 ... If this statement is a SELECT statement and the Nth column of the returned result set of that SELECT is a table column (not an expression or subquery) then the declared type of the table column is returned. If the ...