Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Clarify the meaning of the TEMP keyword on CREATE TABLE. (CVS 2559) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
1a573619f558d1d67775d17aabb9d704 |
| User & Date: | drh 2005-07-22 23:56:50 |
Context
|
2005-07-23
| ||
| 00:41 | First code for the ANALYZE command. Mostly untested. The analysis is not loaded into the symbol tables and is not used by the optimizer. (CVS 2560) (check-in: a4886b11 user: drh tags: trunk) | |
|
2005-07-22
| ||
| 23:56 | Clarify the meaning of the TEMP keyword on CREATE TABLE. (CVS 2559) (check-in: 1a573619 user: drh tags: trunk) | |
| 22:53 | Correct the documentation to show that sqlite3_column_text() returns a NULL pointer (not an empty string) when the column value is NULL. The same goes for sqlite3_column_blob(). Ticket #1334. (CVS 2558) (check-in: fd1e013a user: drh tags: trunk) | |
Changes
Changes to www/lang.tcl.
1
2
3
4
5
6
7
8
9
10
11
...
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
|
#
# Run this Tcl script to generate the lang-*.html files.
#
set rcsid {$Id: lang.tcl,v 1.93 2005/06/26 20:00:46 drh Exp $}
source common.tcl
if {[llength $argv]>0} {
set outputdir [lindex $argv 0]
} else {
set outputdir ""
}
................................................................................
PRIMARY KEY. An INTEGER PRIMARY KEY column man also include the
keyword AUTOINCREMENT. The AUTOINCREMENT keyword modified the way
that B-Tree keys are automatically generated. Additional detail
on automatic B-Tree key generation is available
<a href="autoinc.html">separately</a>.</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. Any indices created on a temporary table
are also temporary. Temporary tables and indices are stored in a
separate file distinct from the main database file.</p>
<p> If a <database-name> is specified, then the table 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,
|
|
|
>
|
|
|
1
2
3
4
5
6
7
8
9
10
11
...
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
|
#
# Run this Tcl script to generate the lang-*.html files.
#
set rcsid {$Id: lang.tcl,v 1.94 2005/07/22 23:56:50 drh Exp $}
source common.tcl
if {[llength $argv]>0} {
set outputdir [lindex $argv 0]
} else {
set outputdir ""
}
................................................................................
PRIMARY KEY. An INTEGER PRIMARY KEY column man also include the
keyword AUTOINCREMENT. The AUTOINCREMENT keyword modified the way
that B-Tree keys are automatically generated. Additional detail
on automatic B-Tree key generation is available
<a href="autoinc.html">separately</a>.</p>
<p>If the "TEMP" or "TEMPORARY" keyword occurs in between "CREATE"
and "TABLE" then the table that is created is only visible
within that same database connection
and is automatically deleted when
the database connection is closed. Any indices created on a temporary table
are also temporary. Temporary tables and indices are stored in a
separate file distinct from the main database file.</p>
<p> If a <database-name> is specified, then the table 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,
|