Small. Fast. Reliable.
Choose any three.

SQLite Requirement Matrix Details
lang_naming.html

Index Summary Markup Original


R-33528-20612-64279-03791-45165-25207-10127-32608 tcl slt th3 src

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.

tcl/e_resolve.test:55

/* IMP: R-33528-20612 */
# EVIDENCE-OF: R-33528-20612 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.

R-37286-42536-47612-10625-41273-62615-36449-24349 tcl slt th3 src

/* 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 */

tcl/e_resolve.test:111

/* IMP: R-37286-42536 */
# EVIDENCE-OF: R-37286-42536 /* 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
# */

R-00634-08585-41820-07623-11518-51863-15995-51786 tcl slt th3 src

If a schema name is specified as part of an object reference, it must be either "main", or "temp" or the schema-name of an attached database.

tcl/e_resolve.test:68

/* IMP: R-00634-08585 */
# EVIDENCE-OF: R-00634-08585 If a schema name is specified as part of an
# object reference, it must be either "main", or "temp" or the
# schema-name of an attached database.

R-17446-42210-34693-14358-63736-15125-50788-14623 tcl slt th3 src

Like other SQL identifiers, schema names are case-insensitive.

tcl/e_resolve.test:82

/* IMP: R-17446-42210 */
# EVIDENCE-OF: R-17446-42210 Like other SQL identifiers, schema names
# are case-insensitive.

R-14755-58619-21710-46731-49779-58295-52088-49443 tcl slt th3 src

If a schema name is specified, then only that one schema is searched for the named object.

tcl/e_resolve.test:91

/* IMP: R-14755-58619 */
# EVIDENCE-OF: R-14755-58619 If a schema name is specified, then only
# that one schema is searched for the named object.

R-08951-19801-08417-23581-55505-30558-59834-07757 tcl slt th3 src

When searching database schemas for a named object, objects of types that cannot be used in the context of the reference are always ignored.

tcl/e_resolve.test:99

/* IMP: R-08951-19801 */
# EVIDENCE-OF: R-08951-19801 When searching database schemas for a named
# object, objects of types that cannot be used in the context of the
# reference are always ignored.