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.