Description

The SQL keyword DROP VIEW is used to delete an existing view, which deletes the view and its contents permanently from a database system.

  • A view name with spaces must be enclosed within double quotes or square brackets.

The below SQL deletes an existing view, with the name "SpainCustomers".

DROP VIEW SpainCustomers;

The below SQLs delete an existing view, with the name "Spain Customers".

DROP VIEW [Spain Customers];
DROP VIEW "Spain Customers";

Related Links