Dropping a view
When you drop a view, you also drop all views that are defined on that view. The base table is not affected.
Example
DROP VIEW VDEPTM; The following SQL statement drops the VDEPTM view:
When you drop a view, you also drop all views that are defined on that view. The base table is not affected.
DROP VIEW VDEPTM;