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