15.00 - DROP VIEW - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

DROP VIEW

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.