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 with SUPER privileges.

  • This command can be run on the master aggregator node, or a child aggregator node (see Node Requirements for SingleStore DB Commands ).

Examples

DROP VIEW inventory_view;
DROP VIEW IF EXISTS inventory_view;