Drop View

DROP VIEW [db_name.]view_name

Drop a logical view on one or more tables.

Examples

-- Drop the global temp view, temp view, and persistent view.
DROP VIEW global_temp.global_DeptSJC;
DROP VIEW temp_DeptSFO;
DROP VIEW database1.view_deptDetails;