SQL DROP VIEW


David Haertzen David Haertzen, Tutorial Author
Check out our
Data Warehousing Tutorial.
Previous | Next

SQL > SQL Administration > SQL DROP VIEW Statement

What is the SQL DROP VIEW Statement?

The SQL DROP VIEW statement is the SQL command that removes an entire SQL view.

Why Use the SQL DROP VIEW Statement?

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.

How To Use the SQL DROP VIEW Statement

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
 

Copyright© 1999-2015, First Place Software, Inc.