Small. Fast. Reliable.
Choose any three.

Search results 1..10 of 133 for: CREATE TABLE

CREATE VIRTUAL TABLE
(lang_createvtab.html)
 ... In general, you can do anything with a virtual table that can be done with an ordinary table, except that you cannot create indices or triggers on a virtual table. Some virtual table implementations might impose additional restrictions. For example ... 
CREATE TABLE
(lang_createtable.html)
 ... The CREATE TABLE command The "CREATE TABLE" command is used to create a new table in an SQLite database. A CREATE TABLE command specifies the following attributes of the new table: The name of the new table. The database in ... 
Imposter Tables
(imposter.html)
2.1. Manually Created Imposter Tables One way to create an imposter table is to directly edit the sqlite_schema table to insert a new row that describes the table. For example, suppose the schema is like this: CREATE TABLE t1(a INTEGER PRIMARY KEY,b TEXT ... 
The Schema Table
(schematab.html)
3. Interpretation Of The Schema Table  ... This SQL text is a CREATE TABLE, CREATE VIRTUAL TABLE, CREATE INDEX, CREATE VIEW, or CREATE TRIGGER statement that if evaluated against the database file when it is the main database of a database connection would recreate the object. The ... 
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 ... 
Swarmvtab Virtual Table
(swarmvtab.html)
1. Overview  ... A swarmvtab table has the same schema as each of its component tables. A swarmvtab virtual table is created as follows: CREATE VIRTUAL TABLE temp.<name> USING swarmvtab(<sql-statement>); Swarmvtab virtual tables must be created ... 
Indexes On Expressions
(expridx.html)
2. Restrictions There are certain reasonable restrictions on expressions that appear in CREATE INDEX statements: Expressions in CREATE INDEX statements may only refer to columns of the table being indexed, not to columns in other tables. Expressions in CREATE INDEX statements may ... 
SQLite FTS5 Extension
(fts5.html)
Appendix B: Shadow tables created by FTS5 When an FTS5 virtual table is created in a database, between 3 and 5 real tables are created in the database. These are known as "shadow tables", and are used by the virtual table module to store persistent data. They ... 
The RBU Extension
(rbu.html)
2.2.3. Using RBU with FTS3/4 Tables Usually, an FTS3 or FTS4 table is an example of a virtual table with a rowid that works like a PRIMARY KEY. So, for the following FTS4 tables: CREATE VIRTUAL TABLE ft1 USING fts4(addr, text); CREATE VIRTUAL TABLE ft2 ... 
1.2. Creating and Destroying FTS Tables Like other virtual table types, new FTS tables are created using a CREATE VIRTUAL TABLE statement. The module name, which follows the USING keyword, is either "fts3" or "fts4". The virtual table module arguments may be left empty, in which ... 

12345678910

Page generated by FTS5 in about 359.59 ms.