This Regex will match anything Starting with CREATE, using negative lookahead to not match the OR REPLACE, picking up anything till the next semicolon.

CREATE(?! OR REPLACE)[\S\n\s]*?;