Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio / nhilam |
Follow
824
|
Create Table Options
CREATE [ { TEMPORARY | TEMP } ] TABLE database-name.table_name ( [
{ column_name data_type [ DEFAULT default_expr ] [ column_constraint [ ... ] ]
| table_constraint
[, ... ]
] )
where column_constraint is:
[ CONSTRAINT constraint_name ]
{ NOT NULL | NULL } conflict-clause
PRIMARY KEY [ { ASC | DESC } ] conflict-clause AUTOINCREMENT |
UNIQUE [ conflict-clause |
CHECK (expression) |
DEFAULT { SIGNED-NUMBER | LITERAL-VALUE | EXPRESSION }
COLLATE collation-name
and table_constraint is:
[ CONSTRAINT constraint_name ]
{ PRIMARY KEY ( column_name [, ... ] ) |
UNIQUE ( column_name [, ... ] ) |
CHECK ( expression ) |
FOREIGN KEY ( column_name [, ... ] ) REFERENCES reftable [ ( refcolumn [, ... ] ) ]
[ MATCH NAME ]
[ ON DELETE { SET NULL | SET DEFAULT | CASCADE | RESTRICT | NO ACTION } ]
[ ON UPDATE { SET NULL | SET DEFAULT | CASCADE | RESTRICT | NO ACTION } ] }
[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]
CREATE VIEW
Creates a view in a database in the SQLite database
Synopsis
CREATE [ { TEMP | TEMPORARY } ] VIEW database-name.view-name AS select-stmt
CREATE TRIGGER
Creates a trigger in a database in the SQLite database
CREATE [ { TEMP | TEMPORARY } ] TRIGGER database-name.trigger-name [ { BEFORE | AFTER | INSTEAD OF } ]
[ { DELETE | INSERT | UPDATE } ] OF [ { column-name,} ] ON table-name
[ {For Each Row} ] WHEN expression
BEGIN
[ { update-stmt | insert-statement | delete-statement | select-stmt} ] ;
END
DROP TRIGGER
Drops a trigger in the SQLite database
Synopsis
DROP TRIGGER database-name.trigger-name
CREATE INDEX
Creates an index for a table in the SQLite database
Synopsis
CREATE [ { UNIQUE } ] INDEX database-name.index-name ON table-name (indexed-columns)
indexed-columns:
column-name [COLLATE collation-name] ASC | DESC
DROP INDEX
Drops an index for a table in the SQLite database
Synopsis
DROP INDEX database-name.index-name
ALTER TABLE
Alters a table and rename or add new column to existing tables.
Synopsis
ALTER TABLE database-name.table-name RENAME TO new-table-name [ADD COLUMN column-def]
REINDEX
The REINDEX command is used to delete and recreate indices from scrath.
Synopsis
REINDEX database-name.table-name index-name
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017