Skip to main content

SingleStoreDB v8.1

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 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;
In this section: