Table Scope

Options for temporary tables

Grammar Syntax

<table scope> ::=
  <global or local>  TEMPORARY
<global or local> ::=
    GLOBAL
  | LOCAL

Click here to go to the ANSI SQL Standard specification for this syntax.

This syntax is fully supported by Snowflake.

Sample Source Patterns

ANSI SQL Input Code

CREATE GLOBAL TEMPORARY TABLE TABLE01 (COLNAME VARCHAR(20));
CREATE LOCAL TEMPORARY TABLE TABLE01 (COLNAME VARCHAR(20));
CREATE TEMPORARY TABLE TABLE01 (COLNAME VARCHAR(20));

Snowflake Output Code

CREATE GLOBAL TEMPORARY TABLE TABLE01 (COLNAME VARCHAR(20));
CREATE LOCAL TEMPORARY TABLE TABLE01 (COLNAME VARCHAR(20));
CREATE TEMPORARY TABLE TABLE01 (COLNAME VARCHAR(20));