Documentation Source Text

Check-in [05fc2c982b]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Change a testable statement mark in lang.in.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 05fc2c982b61a406e8fbd88c88637f71aa996218
User & Date: dan 2010-12-01 11:23:37
Context
2010-12-01
12:57
Fix a requirement mark in the pragma documentation. check-in: 517974ad50 user: drh tags: trunk
11:23
Change a testable statement mark in lang.in. check-in: 05fc2c982b user: dan tags: trunk
2010-11-30
18:13
Fix typos in queryplanner.in check-in: 78db9f1266 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/lang.in.

1379
1380
1381
1382
1383
1384
1385
1386
1387
1388
1389
1390
1391
1392
1393
1394
1395
1396
1397
1398
1399
1400
1401
1402
1403
  its name and the name of its database. ^(If no database is specified as part
  of the object reference, then SQLite searches the main, temp and all attached
  databases for an object with a matching name. The temp database is searched
  first, followed by the main database, followed all attached databases in the
  order that they were attached. The reference resolves to the first match
  found.)^ For example:

^(<pre>
      /* Add a table named 't1' to the temp, main and an attached database */
      ATTACH 'file.db' AS aux;
      CREATE TABLE t1(x, y);
      CREATE TEMP TABLE t1(x, y);
      CREATE TABLE aux.t1(x, y);

      DROP TABLE t1;         /* Drops table in temp database */
      DROP TABLE t1;         /* Drops table in main database */
      DROP TABLE t1;         /* Drops table in aux database */
</pre>)^

<p>
  ^If a database name is specified as part of an object reference, it must be
  either "main", or "temp" or the name of an attached database. ^Like other
  SQL identifiers, database names are case-insensitive. ^If a database name
  is specified, then only the named database is searched for the named object.








|






|
|
|
|







1379
1380
1381
1382
1383
1384
1385
1386
1387
1388
1389
1390
1391
1392
1393
1394
1395
1396
1397
1398
1399
1400
1401
1402
1403
  its name and the name of its database. ^(If no database is specified as part
  of the object reference, then SQLite searches the main, temp and all attached
  databases for an object with a matching name. The temp database is searched
  first, followed by the main database, followed all attached databases in the
  order that they were attached. The reference resolves to the first match
  found.)^ For example:

<pre>^(
      /* Add a table named 't1' to the temp, main and an attached database */
      ATTACH 'file.db' AS aux;
      CREATE TABLE t1(x, y);
      CREATE TEMP TABLE t1(x, y);
      CREATE TABLE aux.t1(x, y);

      DROP TABLE t1;         /* Drop table in temp database */
      DROP TABLE t1;         /* Drop table in main database */
      DROP TABLE t1;         /* Drop table in aux database */
)^</pre>

<p>
  ^If a database name is specified as part of an object reference, it must be
  either "main", or "temp" or the name of an attached database. ^Like other
  SQL identifiers, database names are case-insensitive. ^If a database name
  is specified, then only the named database is searched for the named object.