How to create (global) temporary table with liquibase?

General Discussion
1

Hi,


I don’t see any options how a global temporary table could be created with liquibase. The createTable doesn’t have any attribute for this purpose.


Oracle global temporary table is useful for having a temporary table for each session. So applications don’t have to create it for each session.

CREATE GLOBAL TEMPORARY TABLE my_temp_table (

  column1  NUMBER,

  column2  NUMBER

) ON COMMIT DELETE ROWS;


MsSQL also have a similar concept, local temporary tables. However, it offers global temporary table visible across all sessions, too.

CREATE TABLE #my_temp_table (

  COL1 INT,

  COL2 VARCHAR(30),

  COL3 DATETIME DEFAULT GETDATE()

)


Could the option for temporary tables (at least Oracle global and MsSQL local temporary tables) added to create table refactoring command or a new command?


Thanks,

   Ferenc