DROP USER user-name 

DBA authority.

None.

None.

• ALTER LOGIN POLICY statement
• ALTER USER statement
• COMMENT statement
• CREATE LOGIN POLICY statement
• CREATE USER statement
• DROP LOGIN POLICY statement
• Managing login policies

The following example drops the user SQLTester from a database.

DROP USER SQLTester;