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:
CREATE LOCAL TEMPORARY TABLE TABLE01 (
col1 INTEGER
);
CREATE GLOBAL TEMPORARY TABLE TABLE02 (
col1 INTEGER
);
CREATE TABLE #TABLE03(
col1 INTEGER
);
Output Code:
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.
Last updated