Re: [sqlite] Question about sqlite TEMP table

On Fri, 2005-07-22 at 19:44 -0300, Ming Qiang Lin wrote: > It says that temp table is visible to the process it created, but how > about in this same process, I join a temp table with non-temp table?. > Since I am having Exception says: "no such table" when I do the join. > The text is wrong and

[sqlite] Question about sqlite TEMP table

Hi All, Following is the sqlite CREATE TABLE definition: If the "TEMP" or "TEMPORARY" keyword occurs in between "CREATE" and "TABLE" then the table that is created is only visible to the process that opened the database and is automatically deleted when the database is closed. Any indices create