Drops the definition of a specified view from the Data Dictionary.
When you drop a view, the system:
- Sets an EXCLUSIVE lock on the view.
- Frees the disk space used by the dropped view and any fallback copy.
- Removes any explicit access privileges on the object.
- Removes the metadata for the dropped object from the data dictionary. This includes dropping any statistics collected on the view from DBC.StatsTbl.
ANSI Compliance
DROP VIEW is ANSI SQL:2011-compliant.
Required Privileges
You must have the appropriate DROP privilege on the specified view.