Re: [sqlite] Where are temporary tables/indices stored?

Of course!! Thanks Dennis :-) -- Tito On 01/09/2005, at 23:05, Dennis Cote wrote: Tito Ciuro wrote: If I execute a statement such as 'CREATE TEMP TABLE...' without specifying the database name, where is the SQL statement stored? I've tried using 'temp' as the database name, but it

Re: [sqlite] Where are temporary tables/indices stored?

Tito Ciuro wrote: If I execute a statement such as 'CREATE TEMP TABLE...' without specifying the database name, where is the SQL statement stored? I've tried using 'temp' as the database name, but it doesn't return anything. Tito, The temp table information is stored in a second master

[sqlite] Where are temporary tables/indices stored?

Hello, Regarding the TEMP keyword, the documentation states: If the "TEMP" or "TEMPORARY" keyword occurs in between "CREATE" and "TABLE" then the table that is created is only visible within that same database connection and is automatically deleted when the database connection is