If Not Exists

Create table option

Description

If any table exists with the same name, the CREATE statement has no effect.

Sample Source

Hive

CREATE TABLE IF NOT EXISTS table1 ( 
    col1 integer
);

Snowflake

CREATE TABLE IF NOT EXISTS table1 ( 
    col1 integer
); 

Known Issues

No issues were found.

No related EWIs.

Last updated

Was this helpful?