But it doesn't explain what is "the temp database". Is it an actual database file? Or it is just a in-memory database?
On 2/1/20, Simon Slavin <slav...@bigfraud.org> wrote: > 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 > -- Regards, Peng _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users