15.00 - DROP TABLE - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

DROP TABLE

DROP Processes for DROP TABLE

The system pursues the following process to drop a table:

1 Sets an EXCLUSIVE lock on the table.

2 Frees the disk space used by the dropped table (including any secondary index subtables) 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 stage does not apply to volatile tables because the data dictionary does not maintain metadata for them.