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 doesn't
return anything.
Tito,
The temp table information is stored in a second master table, just
like the sqlite_master table, called sqlite_temp_master. Try this:
create temp table t(1,b);
select * from sqlite_temp_master;
HTH
Dennis Cote