I have added this in the Before Create script under "Table DDL Transformations"
ddl = "IF NOT EXISTS (SELECT * FROM sysobjects WHERE name= '" + table.getLongName() + "')";
As expected, it seems to apply only to the tables.
However, I have a bunch of ALTER table statements following the table creation for Primary and Foreign keys.
I do not want them to fail.
Is there a way to generate such conditions for other artifacts in Oracle SDDM?
only tables are covered for now