DROP USER command in SQL Server

This article will show you in detail how to use the DROP USER command in SQL Server with specific syntax and examples to better visualize and capture commands.

This article will show you in detail how to use the DROP USER command in SQL Server with specific syntax and examples to better visualize and capture commands.

DROP USER command description in SQL Server

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

Syntax of the DROP USER command in SQL Server

The DROP USER command has the following syntax:

 DROP USER user_name; 

Parameters:

  1. user_name: The user name you want to delete from the SQL Server database

Note:

  1. Before you want to remove a user, you need to make sure that you delete all the objects of that user or transfer the object handling to another account if needed.

Example of a DROP USER command in SQL Server

Suppose you want to delete a database user named quantrimang in SQL Server. The DROP USER command will only run when quantrimang no longer has any objects in the database. Then we use the following command:

 DROP USER quantrimang; 

See more:

  1. VIEW in SQL Server
  2. JOIN in SQL Server

Previous article: Change user password, login in SQL Server

Next article: Find User in SQL Server

5 ★ | 1 Vote