Attach database issue sqlite
<p>I'm importing a csv to a table in the database in the following way.
In terminal:</p>

<pre><code>Terminal&gt;sqlite3 test.db 
sqlite3&gt;.import  /Users/Downloads/test.csv trial1
sqlite3&gt; attach database 'test.db' as 'alias_test';
sqlite3&gt; .database

seq  name             file                                                      
---  ---------------  ----------------------------------------------------------
0    main             /Users/Downloads/testattach.db                       
2    test_alias       /Users/Downloads/testattach.db                       
</code></pre>

<p>But when I restart the terminal and type:</p>

<pre><code>&gt;sqlite3 test.db '.database'
</code></pre>

<p>I get:</p>

<pre><code>seq  name             file                                                      
---  ---------------  ----------------------------------------------------------
0    main             /Users/Downloads/testattach.db    
</code></pre>

<p>I want to understand why the attached database name is not shown when I access the database again.</p>