SQLite Forum

DROP VIEW IF EXISTS failure
Login
> It is your job to command what you mean.

I *am* commanding what I mean. I want a view to be dropped if it exists. That's exactly as the documentation says.

> However, in the case of table-like objects which may be the target of SELECT FROM, you may issue a command naming the wrong object type, in which case you get informed of YOUR error.

Between the following two scenarios, there's absolutely no difference. Both are, of course, my error:

a) trying to drop something that doesn't exist at all

b) trying to drop a view where a table with this name exists

Following your argument, situation a) would have to raise an error as well.