SQL Server: DROP USER statement

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

Description

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

Syntax

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

DROP USER user_name;

Parameters or Arguments

user_name

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

Note

• 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.

Example

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.