Choose Category
CREATE GLOBAL TEMPORARY TABLE table_1 ( column1 datatype, column2 datatype, . . columnN datatype );
CREATE GLOBAL TEMPORARY TABLE employee ( ID INT, Name VARCHAR(20) );
CREATE GLOBAL TEMPORARY TABLE table_1 ( column1 datatype, column2 datatype, . . columnN datatype ) ON COMMIT PRESERVE ROWS;