RE: Create table only if does not exist?

I just tried this and it seems to works. You can also put multiple create
tables statements in there for more than one table. If the first one
exists, it will just skip the create and move to the next create table.

begin
declare continue handler for sqlexception
begin end;
create table...
end;

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Justin
Taylor
Sent: Thursday, April 3, 2025 11:14 AM
To: MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Create table only if does not exist?

I have a SQL script (running in ACS RSS) with a CREATE TABLE:

create table MyLib.MyTable as (
-- select statement here
) with data;

If the table already exists, I want the script to skip that statement and
just go on. Any suggestions?

Thanks
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.