TEMPORARY TABLES

Description

In Sybase IQ GLOBAL | LOCAL TEMPORARY is used to create temporary tables that exist only for the session. These tables are session-specific and automatically deleted when the session ends. They help store intermediate results or work data without affecting the permanent database schema. It also can be created only by adding an # at the beginning of the name.

This syntax is partially supported in Snowflake.

Grammar Syntax

CREATE [ { GLOBAL | LOCAL } TEMPORARY ] TABLE 

Sample Source Patterns

Input Code:

Sybase

IN -> Sybase_01.sql

CREATE LOCAL TEMPORARY TABLE TABLE01 (
    col1 INTEGER
);

CREATE GLOBAL TEMPORARY TABLE TABLE02 (
    col1 INTEGER
);

CREATE TABLE #TABLE03(
    col1 INTEGER
);

Output Code:

Sybase

OUT -> Sybase_01.sql

CREATE OR REPLACE TEMPORARY TABLE TABLE01 (
    col1 INTEGER
)
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "sybase",  "convertedOn": "03/19/2025",  "domain": "test" }}'
;

--** SSC-FDM-0009 - GLOBAL TEMPORARY TABLE FUNCTIONALITY NOT SUPPORTED. **
CREATE OR REPLACE TABLE TABLE02 (
    col1 INTEGER
)
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "sybase",  "convertedOn": "03/19/2025",  "domain": "test" }}'
;

CREATE OR REPLACE TEMPORARY TABLE T_TABLE03 (
    col1 INTEGER
)
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "sybase",  "convertedOn": "03/19/2025",  "domain": "test" }}'
;

Related EWIs

SSC-FDM-0009: GLOBAL TEMPORARY TABLE functionality not supported.