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";