Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Removes a SQL Server login account.
.gif "Topic link icon")
Transact-SQL Syntax Conventions
Syntax
DROP LOGIN login_name
Arguments
- login_name
Specifies the name of the login to be dropped.
Remarks
A login cannot be dropped while it is logged in. A login that owns any securable, server-level object, or SQL Server Agent job cannot be dropped.
You can drop a login to which database users are mapped; however, this will create orphaned users. For more information, see Troubleshooting Orphaned Users.
Permissions
Requires ALTER ANY LOGIN permission on the server.
Examples
The following example drops the login WilliJo.
DROP LOGIN WilliJo;
GO
See Also
Reference
CREATE LOGIN (Transact-SQL)
ALTER LOGIN (Transact-SQL)
EVENTDATA (Transact-SQL)