I do not believe that it is possible at all. This thread tells that it is not possible with attached databases https://groups.google.com/forum/#!topic/spatialite-users/rRMSHk2Lt38 and the TEMP database feels like a sort of attached database as well. You must create your temporary tables into the main database and drop them once you do not need them any more.
user30184
- 69k
- 4
- 71
- 125