Description
DROP VIEW removes the metadata associated with a specified view from the catalog.
Syntax
DROP VIEW [ IF EXISTS ] view_identifier
Parameter
-
IF EXISTS - If specified, no exception is thrown when the view does not exists.
-
view_identifier -
Specifies the view name to be dropped. The view name may be optionally qualified with a database name.
Syntax:[ database_name. ] view_name
Example
-- Assumes a view named employeeView exists. DROP VIEW employeeView; +---------+--+ | Result | +---------+--+ +---------+--+
-- Assumes a view named employeeView exists in the userdb database DROP VIEW userdb.employeeView; +---------+--+ | Result | +---------+--+ +---------+--+
-- Assumes a view named employeeView does not exists. -- Throws exception DROP VIEW employeeView; Error: org.apache.spark.sql.AnalysisException: Table or view not found: employeeView; (state=,code=0)
-- Assumes a view named employeeView does not exists,Try with IF EXISTS -- this time it will not throw exception DROP VIEW IF EXISTS employeeView; +---------+--+ | Result | +---------+--+ +---------+--+