DROP USER user-name 

DBA authority.

Dropping a user also deletes all database objects (such as tables or procedures) that they own, as well as any external logins for the user. The user being removed cannot be connected to the database when the statement is executed.

None.

• ALTER LOGIN POLICY statement
• ALTER USER statement
• COMMENT statement
• CREATE LOGIN POLICY statement
• CREATE USER statement
• DROP LOGIN POLICY statement
• Login policies

The following example drops the user SQLTester from a database.

DROP USER SQLTester;