15.00 - After DELETE Structure Remains Intact - 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)

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.