SQLite Forum

DROP VIEW IF EXISTS failure
Login
> The <name> that you are trying to DROP does exist, therefore the clause part "IF EXIST <name>" is true.

No, it does *not* exist as a *view*. And that's what I'm telling SQLite to do: If a *view* named "test" exists, drop it.

> The command is "DROP VIEW IF EXISTS <name>"

No. This is not what I want to do. I just want to drop a view if it exists. If it doesn't exist (as a view), I expect it to do nothing.

MariaDB in this case just issues a waring, which imho is ok because it doesn't stop operation of multiple statements.