On 1 Feb 2020, at 1:30pm, Peng Yu <pengyu...@gmail.com> wrote:

> https://www.sqlite.org/lang_createtable.html
> 
> "The database in which the new table is created. Tables may be created in the 
> main database, the temp database, or in any attached database."
> 
> It is not clear to me in the doc. If a table is created by "create
> temp table", is it temporarily a database file but later got deleted
> upon termination of the sqlite3 session? Or it is in memory? Thanks.

Further down the same page:

" If the "TEMP" or "TEMPORARY" keyword occurs between the "CREATE" and "TABLE" 
then the new table is created in the temp database. "
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to