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.