Where is the documentation on...

The Language Ref does not seem to have any documentation of these attributes of an SQLiteDatabase, but AutoComplete shows them, along with values

  • MainDatabase (value=“Main”), which I assume is the “schema” name for the main database, or the database that attached databases are (uh) attached to

In regards to an “attached” database… you “attach” to the main database using

If currentDB.AttachDatabase(attachDBFile, "locations") Then

but how do you tell if or how many attachments have been made… and what the “schema” name (ie. “locations” in the example) are?
or do you have to create a array/table/collection of these manually?

I hope you do not already read these:

http://developer.xojo.com/userguide/sqlite
http://documentation.xojo.com/index.php/SQLiteDatabase

and:
http://developer.xojo.com/iossqlitedatabase

In Google, I used: site:developer.xojo.com AttachDataBase

Thank you Emile, but those do not address the question…
It is not how to connect to a database, nor how to attach a 2nd (3rd, etc) database to the original connection.

The question is how to determine the SCHEMA name that the user supplied when an attachment was made, and to track (and use) that name during subsequent SQL activities.

For now I have created a class that creates a dictionary of that information… but was hoping that the database class itself handled that.

from https://www.sqlite.org/pragma.html#pragma_database_list

PRAGMA database_list;

This pragma works like a query to return one row for each database attached to the current database connection. The second column is the “main” for the main database file, “temp” for the database file used to store TEMP objects, or the name of the ATTACHed database for other database files. The third column is the name of the database file itself, or an empty string if the database is not associated with a file.

[quote=322652:@Jean-Yves Pochez]from https://www.sqlite.org/pragma.html#pragma_database_list
PRAGMA database_list;.[/quote]
now THAT answered the question. Thanks