Before knowing about what is SQL delete view, it is important to know –
What is SQL view?
A view is a result set of a stored query on the data.
The SQL view is a table which does not physically exist. It is only a virtual table.
SQL VIEW can be created by a SQL query by joining one or more table.
Syntax for SQL create view –
- CREATE VIEW view_name AS
- SELECT columns
- FROM tables
- WHERE conditions;
If you want to delete a SQL view, It is done by SQL DROP command you should use the following syntax:
SQL DROP VIEW syntax:
- DROP VIEW view_name
Why use the SQL DROP VIEW statement?
When a view no longer useful you may drop the view permanently. Also if a view needs change within it, it would be dropped and then created again with changes in appropriate places.