SQLite Forum

DROP VIEW IF EXISTS failure
Login
> It should generally know what sort of things the names represent, at least when it matters.

With this argument, the IF [NOT] EXISTS clause would be needless anywhere.

Again, I do not want to eliminate the error at all. But that's what "DROP VIEW" (without "IF EXISTS") is for. The only purpose of the "IF EXISTS" clause is to suppress the error. And none of the documentations mention that this is only the case when "some table-like object doesn't exist".