SQL DELETE VIEW
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 -
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:
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.
Next TopicSQL Delete Join
JavaTpoint offers too many high quality services. Mail us on h[email protected], to get more information about given services.
JavaTpoint offers college campus training on Core Java, Advance Java, .Net, Android, Hadoop, PHP, Web Technology and Python. Please mail your requirement at [email protected].
Duration: 1 week to 2 week