Drops the definition for an empty user from the Data Dictionary.
This statement is a Teradata extension to the ANSI SQL:2011 standard.
DROP USER is functionally similar to the ANSI SQL:2011 statement DROP SCHEMA.
You must have the DROP USER privilege on the user. The user that is being dropped cannot own other databases or users, and must be at the bottom of the database hierarchy.