Re: Create table only if does not exist?

[cesco <emaxt6@xxxxxxxxx>]

> If the table already exists, I want the script to skip that statement and

Just swallow the exception in the statement block scope.

BEGIN
DECLARE CONTINUE HANDLER FOR SQLSTATE '42710' BEGIN END;

create table lib.MyTable (a) as (
values(1) 
) with data;
create table lib.MyTable1 (a) as (
values(1) 
) with data;

END

-c