Using SQLite

Name

DROP VIEW — Delete a view from a database

Syntax

Common Usage

DROP VIEW database_name.view_name;

Description

The DROP VIEW command removes a view from the database. Although the view will no longer be available, none of the referenced data is altered in any way. Dropping a view will also remove any associated triggers.

Dropping a view that does not exist will normally generate an error. If the optional IF EXISTS clause is provided, this error is silently ignored.

See Also

CREATE VIEW, CREATE TABLE, DROP TRIGGER