2.1. VIRTUAL versus STORED columns  ... Queries against either class of generated column produce the same results. The only functional difference is that one cannot add new STORED columns using the ALTER TABLE ADD COLUMN command. Only VIRTUAL columns can be added using ALTER TABLE.

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

 ... ALTER TABLE ADD COLUMN The ADD COLUMN syntax is used to add a new column to an existing table. The new column is always appended to the end of the list of existing columns. The rule defines the characteristics of ... 

3.2.1. Adding Entries to a Zip Archive  ... To insert a directory into the archive, set the "data" column to NULL. For example, to add the directory "dir1" and the file "m.txt" containing the text "abcdefghi" to zip archive "test.zip": INSERT INTO temp.zip(name, data ... 

 ... Tables, indexes, triggers, and views in unlimited quantity Up to 32K columns in a table and unlimited rows Multi-column indexes Indexes can use DESC and COLLATE Partial indexes Indexes On Expressions Clustered indexes Covering indexes CHECK, UNIQUE, NOT NULL ... 

1. Usage  ... add application-defined collating sequences that are required by the schema. --primarykey Use the schema-defined PRIMARY KEY instead of the rowid to pair rows in the source and destination database. (See additional explanation below.) --schema Show only column name ... 

 ... ABORT ACTION ADD AFTER ALL ALTER ALWAYS ANALYZE AND AS ASC ATTACH AUTOINCREMENT BEFORE BEGIN BETWEEN BY CASCADE CASE CAST CHECK COLLATE COLUMN COMMIT CONFLICT CONSTRAINT CREATE CROSS CURRENT CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP DATABASE DEFAULT DEFERRABLE DEFERRED DELETE DESC DETACH DISTINCT ... 

 ... 2005-03-21 - Version 3.2.0 The primary purpose for version 3.2.0 is to add support for ALTER TABLE ADD COLUMN. The new ADD COLUMN capability is made possible by AOL developers supporting and embracing great open ... 

1. Overview The CSV virtual table reads RFC 4180 formatted comma-separated values, and returns that content as if it were rows and columns of an SQL table. The CSV virtual table is useful to applications that need to bulk-load large ... 

sqlite3_vtab_distinct()

 ... sqlite3_vtab_distinct() return value Rows are returned in aOrderBy order Rows with the same value in all aOrderBy columns are adjacent Duplicates over all colUsed columns may be omitted 0yesyesno 1noyesno 2noyesyes 3yesyesyes For the purposes of comparing virtual table output ...