I am generating the DDL from a modeling tool - ERStudio. But the DDL has 2 issues right now.
DROP TABLE schema_name.
The Constraints is not supported but works with the statement - DROP TABLE Study_Definition.EVENT_STORE CASCADE;
Second if there is no object to drop, it throws an error, so is there a check like in sql server If_Exists that we can use in CacheDB?