SQLite | View | Dropping a View

This article explains how to drop an existing view.

Dropping a View

Use the following syntax to drop an existing view.

DROP VIEW view_name;

Dropping a view does not affect its source table or the data stored in that table.

Before dropping the view, run the SQLite .tables command to list the existing views and tables.

.tables

sqlite> .table
seouluser  user     
sqlite> 

Drop the seouluser view.

drop view seouluser;

sqlite> drop view seouluser;
sqlite> 

Run .tables again to verify that the seouluser view has been dropped.

.tables

sqlite> .table
user
sqlite> 

The result confirms that the seouluser view has been dropped.