DROP VIEW

Syntax

DROP VIEW [IF EXISTS] <view_name>;

DROP VIEW privileges are granted only to the user who created the view and to users with SUPER privileges.
This command can be run on the master aggregator node, or a child aggregator node (see Node Requirements for SingleStore Commands ).
This command causes implicit commits. Refer to COMMIT for more information.
Refer to the Permission Matrix for the required permission.

SQL

DROP VIEW inventory_view;

SQL

DROP VIEW IF EXISTS inventory_view;