Multiple versions of a database
I find that it requires manual changes to the SQL packages built in SQL Packager to build an executable that will apply to all versions of a database. If there were a default SQL option that would allow for a if exists drop statement to be included when a create statement is required or an if exists statement when a drop statement is required, it would make packager more flexible. Currently it appears that you only get a create, drop, or alter statement and the only way to easily add an if exists is to overwrite the print statement before building the executable.
0 · Share on Twitter