DROP VIEW
On this page
Drop a view.
Syntax
DROP VIEW [IF EXISTS] <view_name>;
Remarks
-
DROP VIEW
privileges are granted only to the user who created the view and to users withSUPER
privileges. -
This command causes implicit commits.
Refer to COMMIT for more information. -
Refer to the Permission Matrix for the required permission.
Examples
DROP VIEW inventory_view;
DROP VIEW IF EXISTS inventory_view;
Related Topics
Last modified: May 10, 2024