SQL DELETE VIEWBefore 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 |
We provides tutorials and interview questions of all technology like java tutorial, android, java frameworks
G-13, 2nd Floor, Sec-3, Noida, UP, 201301, India