SingleStore DB

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;