15.00 - After DELETE Structure Remains Intact - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

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

After DELETE Structure Remains Intact

After all the data tables, views, triggers, stored procedures, user‑defined functions, and macros have been deleted from a user, the structure of the emptied user remains intact, as if its CREATE statement had just been performed, and it can be used in a subsequent restore operation. The DELETE USER statement is used when a user has been only partially restored and is not in a usable state.