DROP Processes for DROP VIEW
The system pursues the following process to drop a view:
1 Sets an EXCLUSIVE lock on the view.
2 Frees the disk space used by the dropped view and any fallback copy.
3 Removes any explicit access privileges on the object.
4 Removes the metadata for the dropped object from the data dictionary.
This includes dropping any statistics collected on the view from DBC.StatsTbl.