Lines Matching refs:table

6   database table.
12       at all (a "contentless" FTS4 table), or
14     * The indexed documents are stored in a database table created and
15       managed by the user (an "external content" FTS4 table).
23   In order to create an FTS4 table that does not store a copy of the indexed
25   For example, the following SQL creates such an FTS4 table with three
30   Data can be inserted into such an FTS4 table using an INSERT statements.
41   table. Attempting to do so is an error.
44   an error to attempt to retrieve the value of any table column other than
68   An "external content" FTS4 table is similar to a contentless table, except
70   docid, FTS4 attempts to retrieve that value from a table (or view, or 
71   virtual table) nominated by the user (hereafter referred to as the "content
72   table"). The FTS4 module never writes to the content table, and writing
73   to the content table does not affect the full-text index. It is the
74   responsibility of the user to ensure that the content table and the 
77   An external content FTS4 table is created by setting the content option
78   to the name of a table (or view, or virtual table) that may be queried by
79   FTS4 to retrieve column values when required. If the nominated table does
80   not exist, then an external content table behaves in the same way as
81   a contentless table. For example:
86   Assuming the nominated table does exist, then its columns must be the same 
87   as or a superset of those defined for the FTS table.
89   When a users query on the FTS table requires a column value other than
91   the row in the content table with a rowid value equal to the current FTS
92   docid. Or, if such a row cannot be found in the content table, a NULL
107     -- of columns b and c from the row with rowid=3 in the content table
116     -- table have been modified.
123     -- a row with rowid=3 within the content table.
128   When a row is deleted from an external content FTS4 table, FTS4 needs to
129   retrieve the column values of the row being deleted from the content table.
132   deleted. If the content table row cannot be found, or if it contains values
139   Instead of writing separately to the full-text index and the content table,
141   up to date with respect to the set of documents stored in the content table.
159   on the content table. This is so that FTS4 can still retrieve the original
164   content table, for the same reasons.
168   set of documents in the content table. Assuming again that "t3" is the
169   name of the external content FTS4 table, the command is:
176   FTS4 table.