/
DROP VIEW

DROP VIEW

Removes a view from the current database

Syntax

DROP VIEW [schema_name.]view_name;

Description

This statement only removes the view definition from the database schema, without making any changes to the actual data in the underlying base tables.

See Also

CREATE VIEW

Related content