IF NOT EXISTS

Create table option

Description

If any table exists with the same name, the CREATE statement has no effect. Cannot appear with OR REPLACE.

circle-check

Sample Source

BigQuery (Input Code)

CREATE TABLE IF NOT EXISTS table1 ( 
    col1 integer
);

Snowflake (Output Code)

CREATE TABLE IF NOT EXISTS table1 ( 
    col1 integer
); 

Last updated

Was this helpful?