Hi,
I have my DDL script generation configured to include DROP statements.
My question is how can I get the 'IF EXISTS' clause back into those statements?
In TDM v2.25.0.28 the drop statement appeared as required (see fragement below)
v2.25.0.28 fragement <<<<<<<<<
Drop Procedure IF EXISTS sp_user_roleremove
;
Drop Procedure IF EXISTS sp_user_licence
;
drop table IF EXISTS Point_Designator;
end fragement <<<<<<<<<
Having recently upgraded to TDM 3.3.7.22 I now get
v3.3.7.22 fragement <<<<<<<<<
-- Drop procedures section ---------------------------------------------------
DROP PROCEDURE sp_user_roleremove
;
DROP PROCEDURE sp_user_licence
;
-- Drop tables section ---------------------------------------------------
DROP TABLE Point_Designator
;
end fragement <<<<<<<<<
My model is based on MySQL 5.0.
Thanks in advance
Paul