IF NOT EXISTS

circle-info

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentationarrow-up-right

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected]envelope.

Thank you for your understanding.

Description

Ensures the table is created only if it does not already exist, preventing duplication and errors in your SQL script. (Sybase SQL Language Referencearrow-up-right).

circle-check

Grammar Syntax

IF NOT EXISTS

Sample Source Patterns

Input Code:

IN -> Sybase_01.sql
CREATE TABLE IF NOT EXISTS table1 (
    col1 INTEGER
);

Output Code:

Last updated