DROP VIEW
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 can be run on the master aggregator node, or a child aggregator node (see Node Requirements for SingleStoreDB Commands ).
This command causes implicit commits. See COMMIT for more information.
See the Permission Matrix for the required permission.
Examples
DROP VIEW inventory_view;
DROP VIEW IF EXISTS inventory_view;