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.