DROP VIEW

Drop one or more views.

Table of contents

Synopsis

DROP VIEW [ IF EXISTS ] view_name [ , ... ]

Description

DROP VIEW drops one or more existing views.

If a view doesn’t exist an error will be returned, unless IF EXISTS is used, in which case all matching existing views will be dropped.