Subject Change a regular table to global temporary table
Author PenWin
In my Firebird 1.5 database, I have a table WORK which works pretty much
like Firebird 2.1's global temporary table, except that it's contents
are deleted by application rather than the server (when an application
ends, it DELETEs all records WHERE connection_id=<some number>, and
there are regular DELETEs without conditions to get rid of possibly
forgotten values).

Is it possible to change this "real table" to global temporary table of
Firebird 2.1 without dropping and re-creating it? I have in mind
something like changing its RDB$RELATION_TYPE to 4 - would that be
sufficient for "temporarizing" the table?