SQLite DROP VIEW

The SQLite DROP VIEW statement removes the view from the database. Please exercise caution when using this statement, as it will remove the view and its definition from the database.

Syntax

The general syntax for the SQLite DROP VIEW statement is as follows:

DROP VIEW view_name;

or

DROP VIEW [IF EXISTS] view_name;

Optionally, we can use the IF EXISTS clause to avoid any error if the view doesn’t exist.

Example

Let’s say we have a view named emp_view. This is the view created on the base table emp. To remove the view from the database, we can use the following statement:

/> DROP VIEW IF EXISTS emp_view;

sqlite> .tables
emp emp_view
sqlite> DROP VIEW IF EXISTS emp_view;
sqlite>

Notice the error when the view is not present in the database.

sqlite> .tables
emp
sqlite> DROP VIEW emp_view;
Parse error: no such view: emp_view

sqlite> DROP VIEW IF EXISTS emp_view;
sqlite>

The IF EXISTS clause will suppress the error if the view is not in the database.

 

—

SQLite Tutorials

SQLite tutorials on this website:

https://www.testingdocs.com/sqlite-database-tutorials/

For more information on SQLite, visit the official website:

https://www.sqlite.org/