Global temporary table

GLOBAL TEMPORARY TABLE statement defines a temporary table for the current session. The declared temporary table description does not appear in the system catalog. It is not persistent and cannot be shared with other sessions. Each session that defines a declared global temporary table of the same name has its own unique description of the temporary table. When the session terminates, the rows of the table are deleted, and the description of the temporary table is dropped.

After deletion we do not need to give any storage management command because global temporary tables are system managed and after deletion of data, space which was occupied by table are ready to allocate for other use.