Drop a View
How to Drop a View in SQL
If a view is no longer needed, it may be dropped to simplify the maintenance process and reduce the workload. When you need to drop a view in SQL, you can use the DROP VIEW statement, followed by the view_name you want to drop.
Here’s the syntax:
DROP VIEW view_name;
Views are based on underlying tables; if those tables are modified, the view may no longer deliver the expected results. For example, recreating a view with the updated schema can solve this issue.
Note that dropping a view doesn’t affect the underlying tables and their data, but it will permanently delete the view from the database, and you won’t be able to recover it.