After DELETE Structure Remains Intact - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
imq1591724555718.ditamap
dita:ditavalPath
imq1591724555718.ditaval
dita:id
B035-1184
lifecycle
previous
Product Category
Teradata Vantage™

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.