16.20 - DROP Processes - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)

The drop operation verifies that the user is empty, checks that the user does not own any other databases or users, drops the user, and adds the PERM and TEMPORARY space that the drop makes available to that of the immediate owner database or user.

After a user is dropped, it cannot be recovered by using the Dump and Restore utility unless it is restored.