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 (
) 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 (
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?