DROP VIEW
說明
DROP VIEW 從目錄中移除與指定檢視相關的元資料。
語法
DROP VIEW [ IF EXISTS ] view_identifier
參數
-
IF EXISTS
如果指定，當檢視不存在時，不會擲回例外。
-
view_identifier
指定要刪除的檢視名稱。檢視名稱可以選擇使用資料庫名稱限定。
語法：
[ database_name. ] view_name
範例
-- Assumes a view named `employeeView` exists.
DROP VIEW employeeView;
-- Assumes a view named `employeeView` exists in the `userdb` database
DROP VIEW userdb.employeeView;
-- Assumes a view named `employeeView` does not exist.
-- 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 exist,Try with IF EXISTS
-- this time it will not throw exception
DROP VIEW IF EXISTS employeeView;