SQL As Understood By SQLite

DROP VIEW

sql-command ::= DROP VIEW view-name

The DROP VIEW statement removes a view created by the CREATE VIEW statement. The name specified is the view name. It is removed from the database schema, but no actual data in the underlying base tables is modified.