SQL Server: DROP USER statement

This SQL Server tutorial explains how to use the SQL Server DROP USER statement with syntax and examples.


The DROP USER statement is used to remove a user from the SQL Server database.


The syntax for the DROP USER statement in SQL Server (Transact-SQL) is:

DROP USER user_name;

Parameters or Arguments

The name of the user to remove from the SQL Server database.


  • Before you can drop a user, you must delete objects owned by the user or transfer ownership of those objects.
  • See also the CREATE USER statement.


Let’s look at how to drop a user using the DROP USER statement in SQL Server.

For example:

DROP USER techonthenet;

This DROP USER example would drop the user called techonthenet. This DROP USER statement will only run if techonthenet does not own any objects in the SQL Server database.