whytwelve13@xxxxxxxxx wrote:
I am using 8.1.5, which doesn't have IF EXISTS yet. Although, this is a good addition to the language. How do I ignore the error? The problem is that I would like to have a set of drop/create statements executed at once and one drop failingwill abort the script execution.
Not exactly what you're looking for, but I just thought I'd check that you know about the CREATE OR REPLACE ... form of most create statements.
-- Richard Huxton Archonet Ltd