Deletes all data tables, views, triggers, SQL procedures, macros, and user-installed files (UIFs) from a user.
This statement does not delete the definition for a user from the dictionary. See DROP USER.
Also see the following sections:
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
Required Privileges
You must have the DROP privilege on the specified user.