TechyCage Technology Releated Articles

Wednesday, 2 March 2016

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

EXAMPLE

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

0 comments:

Post a Comment

Subscribe to RSS Feed Follow me on Twitter!