Basic about GLOBAL TEMPORARY TABLES – using and example

This SQL tutorial explains how to create SQL GLOBAL TEMPORARY tables with syntax and examples.

Description

SQL GLOBAL TEMPORARY TABLES are tables that are created distinct within SQL sessions.

Syntax

The syntax for CREATE GLOBAL TEMPORARY TABLE in SQL is:

CREATE GLOBAL TEMPORARY TABLE table_name
( column1 datatype [ NULL | NOT NULL ],
  column2 datatype [ NULL | NOT NULL ],
  ...
);

Parameters or Arguments

table_name The title of the global transient table that you desire to create. column1, column2 The columns that you want to create in the international transient table. Each column must have a datatype. The column either be defined as NULL or NOT NULL and if this cost is left blank, the database assumes NULL as the default.

Example

Let’s seem at a SQL CREATE GLOBAL TEMPORARY TABLE example:

CREATE GLOBAL TEMPORARY TABLE suppliers_temp
( supplier_id numeric(10) NOT NULL,
  supplier_name char(50) NOT NULL,
  contact_name char(50)
);

This example would create a GLOBAL TEMPORARY TABLE called suppliers_temp.