The SQL DROP VIEW statement is the SQL command that removes an entire SQL view.
You may drop an view permanently when it is no longer useful or temporarily. If the view is not useful it could be dropped.
Also, if a view needs to be changed it would be dropped and then created again with changes in place.
The SQL DROP VIEW command is used as follows.
SQL DROP VIEW Statement Syntax
DROP VIEW <view_name>.<
SQL DROP VIEW Statement Example
The following example drops a view named V_PERSON.
DROP VIEW V_PERSON