otherwise the few ms between "drop" and "create" will lead to outages if used in prod
also - the fact that we can't rollback means that if there is a syntax error, we would have dropped and never reapplied (hopefully users would have tested it before, but still would be better to not even have the risk)
e.g., instead of DROP, CREATE
REPLACE CREATEw/CREATE IF NOT EXISTS``