Use the DROP VIEW statement to destroy a view. As a view is physically independent of its underlying table(s), you can drop the view at any time without affecting the table(s). All SQL programs, applications, and other views that reference the dropped view will break, however.
DROP VIEW view;
DROP VIEW ny_authors;
Dropping a table doesn’t drop the views that reference that table, so you must drop the views with DROP VIEW explicitly; see “Dropping a Table with DROP TABLE” in Chapter 10.
SQL has no ALTER VIEW statement. If the underlying table(s) or view(s) changed since a view was created, ...