Dropping Views
The command for removing views is:
DROP VIEW view_name
If a view depends on a table (or on another view) that has been dropped, you won't be able to use the view. However, if you create a new table (or view) with the same name to replace the dropped one, you may be able to use the view again, as long as the columns referenced in the view definition still exist. Check your system's reference manuals for details.
Get Practical SQL Handbook, The: Using SQL Variants, Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
