Drop View

Important

This documentation has been retired and might not be updated. The product, service, or technology mentioned in this content is no longer supported. See 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;