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 causes implicit commits. Refer to COMMIT for more information.

  • Refer to the Permission Matrix for the required permission.

Examples

DROP VIEW inventory_view;
DROP VIEW IF EXISTS inventory_view;

Last modified: May 10, 2024

Was this article helpful?