Small. Fast. Reliable.
Choose any three.
Choose any three.
|
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 ...
|
|
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 ...
|
|
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 ...
|
|
CREATE TRIGGER
(lang_createtrigger.html)
... TEMP Triggers on Non-TEMP Tables
A trigger normally exists in the same database as the table named
after the "ON" keyword in the CREATE TRIGGER statement. Except, it is
possible to create a TEMP TRIGGER on a table in ...
|
|
CREATE INDEX
(lang_createindex.html)
... Syntax
The CREATE INDEX command consists of the keywords "CREATE INDEX" followed
by the name of the new index, the keyword "ON", the name of a previously
created table that is to be indexed, and a parenthesized list of table ...
|
|
List of SQLite Syntax Diagrams
(syntax.html)
List of SQLite Syntax Diagrams
aggregate-function-invocation
alter-table-stmt
analyze-stmt
attach-stmt
begin-stmt
column-constraint
column-def
column-name-list
comment-syntax
commit-stmt
common-table-expression
compound-operator
compound-select-stmt
conflict-clause
create-index ...
|
|
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 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)
3.1. SQL Parameters
... CREATE VIRTUAL TABLE temp.x1 USING swarmvtab (
"SELECT :dir || local_filename, tbl, min, max FROM components",
:dir = '/home/user/app/databases/'
);
When the above CREATE VIRTUAL TABLE statement is executed, swarmvtab binds
the text value "/home/user/app/databases/" to the ...
|
Page generated by FTS5 in about 140.02 ms.