SQLite Forum

DROP VIEW IF EXISTS failure
Login
> Advantages of "DROP VIEW IF EXISTS" raising an error: ?? (I would say: none; those who want errors simply leave out the "IF EXISTS" clause)

I think it would be more counter-intuitive for `CREATE VIEW x` to fail after `DROP VIEW IF EXISTS x` returned no error than for `DROP VIEW IF EXISTS x` to fail even though `x` is a table and not a view.