The Opened command returns a table that lists all opened databases for the given connection.

The key in the table is the name of the database and the value is the file name.

For in-memory or temporary databases, the file name is an empty string.

$\mathrm{with}\left({\mathrm{Database}}_{\mathrm{SQLite}}\right)\:$

$\mathrm{db}≔{\mathrm{FileTools}}_{\mathrm{JoinPath}}\left(\left[\mathrm{kernelopts}\left(\'\mathrm{datadir}\'\right)\,''SQLite''\,''G20-Population.db''\right]\right)\:$

$\mathrm{connection}≔\mathrm{Open}\left(\mathrm{db}\right)$

$''SQLite\; database'',table\left(\left[''main''=''C:\backslash Program\; Files\backslash Maple\; 2023\backslash data\backslash SQLite\backslash G20-Population.db''\right]\right)$

$\mathrm{Attach}\left(\mathrm{connection}\,'':memory:''\,''database2''\right)\:$

$\mathrm{Opened}\left(\mathrm{connection}\right)$

$''SQLite\; database'',table\left(\left[''main''=''C:\backslash Program\; Files\backslash Maple\; 202\backslash data\backslash SQLite\backslash G20-Population.db''\,''database2''=''''\right]\right)$

$\mathrm{Close}\left(\mathrm{connection}\right)$

$''SQLite\; database:\; connection\; closed''$

The Database[SQLite][Opened] command was introduced in Maple 18.

For more information on Maple 18 changes, see Updates in Maple 18.