Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | fix typo in CREATE VIEW documentation. Ticket #1135. (CVS 2411) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | 38897a509a98188a06c49c01a71ddf8835c7b607 |
| User & Date: | drh 2005-03-21 01:24:02 |
Context
|
2005-03-21
| ||
| 01:31 | Update docs to say that the default_synchronous pragma has been removed. Ticket #1049. (CVS 2412) check-in: 21012bba user: drh tags: trunk | |
| 01:24 | fix typo in CREATE VIEW documentation. Ticket #1135. (CVS 2411) check-in: 38897a50 user: drh tags: trunk | |
| 01:20 | Fix an infinite loop in the code generator for INSERT. Ticket #1140. (CVS 2410) check-in: 876d09d9 user: drh tags: trunk | |
Changes
Changes to www/lang.tcl.
1
2
3
4
5
6
7
8
9
10
11
...
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
|
#
# Run this Tcl script to generate the lang-*.html files.
#
set rcsid {$Id: lang.tcl,v 1.88 2005/03/21 00:28:24 drh Exp $}
source common.tcl
if {[llength $argv]>0} {
set outputdir [lindex $argv 0]
} else {
set outputdir ""
}
................................................................................
</p>
<p>If the "TEMP" or "TEMPORARY" keyword occurs in between "CREATE"
and "TABLE" then the table that is created is only visible to the
process that opened the database and is automatically deleted when
the database is closed.</p>
<p> If a <database-name> is specified, then the view is created in
the named database. It is an error to specify both a <database-name>
and the TEMP keyword, unless the <database-name> is "temp". If no
database name is specified, and the TEMP keyword is not present,
the table is created in the main database.</p>
<p>You cannot COPY, DELETE, INSERT or UPDATE a view. Views are read-only
in SQLite. However, in many cases you can use a <a href="#createtrigger">
TRIGGER</a> on the view to accomplish the same thing. Views are removed
with the <a href="#dropview">DROP VIEW</a>
|
|
|
|
|
|
1
2
3
4
5
6
7
8
9
10
11
...
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
|
#
# Run this Tcl script to generate the lang-*.html files.
#
set rcsid {$Id: lang.tcl,v 1.89 2005/03/21 01:24:02 drh Exp $}
source common.tcl
if {[llength $argv]>0} {
set outputdir [lindex $argv 0]
} else {
set outputdir ""
}
................................................................................
</p>
<p>If the "TEMP" or "TEMPORARY" keyword occurs in between "CREATE"
and "TABLE" then the table that is created is only visible to the
process that opened the database and is automatically deleted when
the database is closed.</p>
<p> If a <database-name> is specified, then the view is created in
the named database. It is an error to specify both a <database-name>
and the TEMP keyword, unless the <database-name> is "temp". If no
database name is specified, and the TEMP keyword is not present,
the table is created in the main database.</p>
<p>You cannot COPY, DELETE, INSERT or UPDATE a view. Views are read-only
in SQLite. However, in many cases you can use a <a href="#createtrigger">
TRIGGER</a> on the view to accomplish the same thing. Views are removed
with the <a href="#dropview">DROP VIEW</a>
|