Re: Is the table created by "create temp table" in the database file or in memory?
Simon Slavin <[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <[email protected]> |
On 1 Feb 2020, at 1:30pm, Peng Yu <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users