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.