check for object existence not working
Posted: Thu 01 Nov 2018 22:25
I have selected the "check for object existence" option when generating the SQL sync scripts, but the resulting SQL does not make any checks
below is a small snippet where I would have expected these statements for check for the table, index and column
below is a small snippet where I would have expected these statements for check for the table, index and column
Code: Select all
--
-- Drop index `om_cmn_location_om_cmn_application_fk` from table `OM_CMN_Application`
--
ALTER TABLE OM_CMN_Application
DROP INDEX om_cmn_location_om_cmn_application_fk;
--
-- Alter column `updatedOnDTime` on table `OM_CMN_Application`
--
ALTER TABLE OM_CMN_Application
CHANGE COLUMN updatedOnDTime updatedOnDTime DATETIME DEFAULT CURRENT_TIMESTAMP;