Database[SQLite]
Attach
attach a new database to the opened connection
Calling Sequence
Parameters
Description
Examples
Compatibility
Attach( connection, filename, name )
connection
-
database connection obtained using the Open command
filename
string; URI file name
name
string; name of database
The Attach command adds a database file to the current database connection. It is a convenience command implementing the ATTACH DATABASE statement.
The database-names main and temp refer to the main database and the database used for temporary tables, respectively. The main and temp databases cannot be attached or detached.
The Attach command can open an existing database from Workbook if the filename is a valid Workbook URI.
with⁡DatabaseSQLite:
Create in memory database
db≔Open⁡:memory::
Create and attach another in memory database
Attach⁡db,:memory:,database2:
Opened databases
Opened⁡db
table⁡database2=,main=
Close database connection
Close⁡db:
The Database[SQLite][Attach] command was introduced in Maple 18.
For more information on Maple 18 changes, see Updates in Maple 18.
The Database[SQLite][Attach] command was updated in Maple 2016.
See Also
Database[SQLite][Open]
Download Help Document