Is the table created by "create temp table" in the database file or in memory?
Peng Yu <[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <CABrM6wm5fkMhg0A-K+bmyVwDBSXv6YqwcS-7vcwbjxJNUe2_TA@mail.gmail.com> |
Hi, 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. -- Regards, Peng _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users