{"id":702,"date":"2019-06-06T01:42:03","date_gmt":"2019-06-06T09:42:03","guid":{"rendered":"https:\/\/db2tutorial.com\/?page_id=702"},"modified":"2020-04-11T06:58:31","modified_gmt":"2020-04-11T14:58:31","slug":"db2-drop-view","status":"publish","type":"page","link":"https:\/\/www.db2tutorial.com\/db2-view\/db2-drop-view\/","title":{"rendered":"Db2 DROP VIEW"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the Db2 DROP VIEW<\/code> statement to remove a view from the database.<\/p>\n\n\n\n

Introduction to DROP VIEW statement<\/h2>\n\n\n\n

To remove a view from the database, you use the DROP VIEW<\/code> statement:<\/p>\n\n\n

DROP<\/span> VIEW<\/span> view_name;\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this syntax, you just need to specify the name of the view that you want to delete in the DROP VIEW<\/code> clause.<\/p>\n\n\n\n
Once you delete the view, Db2 will mark all views that depend on the deleted view inoperative.<\/p>\n\n\n\n
Db2 doesn’t allow you to delete multiple views using a single DROP VIEW<\/code> statement. Therefore, you have to execute multiple DROP VIEW<\/code> statements to delete multiple views.<\/p>\n\n\n\n
In other database systems, you may find that they have DROP VIEW IF EXISTS<\/code>statement to conditionally delete a view only if it exists. However, Db2 doesn’t support IF EXISTS<\/code> clause.<\/p>\n\n\n\n
DB2 DROP VIEW example<\/h2>\n\n\n\n
We’ll use the book_details<\/code> view created in the CREATE VIEW<\/a><\/code> tutorial for the demonstration.<\/p>\n\n\n\n
The following statement uses the DROP VIEW<\/code> statement to remove the view book_details<\/code>:<\/p>\n\n\n
DROP<\/span> VIEW<\/span> book_details;\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this tutorial, you’ve learned how to use the DROP VIEW<\/code> statement to delete a view from the database.<\/p>\n
\n\t
\n\t\t
Was this tutorial helpful ?<\/div>\n\t\t
\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
\n\t\t
\n\t\t\t
<\/div>\n\t\t\t\n\t\t\t