SQLite: drop view

Dropping a view only if it exists

In order to suppress error messages, SQLite supports the drop view if exists clause which only tries to drop a view if it in fact does exist:

create view tq84_vw as
  select 'foo';

drop view if exists tq84_vw;

drop view if exists tq84_vw;