SQLite Forum

DROP VIEW IF EXISTS failure
Login
Ok, maybe I didn't clearly point this out:

I *am* using "DROP VIEW IF EXISTS", and I am expecting it to do nothing. But instead, I get an error which tells me to use "DROP TABLE" -- which is not want I want to. I am expecting "test" to be deleted if it is a view, and otherwise skip silently. That's why I'm using "IF EXISTS". 

The error may be correct for "DROP VIEW", but imho it is not correct for "DROP VIEW IF EXISTS".