SQLite Forum

DROP VIEW IF EXISTS failure
Login
Well, that is interesting.  To be consistent it should return an error that you need to use 'drop table' to drop table t1.

This is an inconsistency so one or the other is incorrect.

```
create table t1(x);
drop trigger if exists t1;
```

also does not return that you have to use "drop table".

Maybe it is because tables and views both reside in the same structure chain in the internal schema data structure.  (That is, a "view" is a table-like object, whereas indexes and triggers are not).