DROP USER (TSQL Statement)

deletes the specified user from the current database.

Syntax

DROP USER user_name

Arguments

user_name
is the name of the user to drop.

Remarks

Only sa or dbo is allowed to execute this statement.

All permissions for this user are also deleted.

Examples

DROP USER alice;
RSQL, a simple alternative to Microsoft SQL Server