DROP LOGIN

Remove a SQL Server login account (User).

Syntax
      DROP LOGIN login_name

Options
   login_name   The login to be dropped.

This command will fail if the user is currently logged in or if the login owns any securable, server-level object, or SQL Server Agent job.

Example

DROP LOGIN Billg;
GO

"I always wanted to be somebody, but I should have been more specific" ~ Lily Tomlin

Related commands:

CREATE LOGIN
ALTER LOGIN
Equivalent Oracle commands: DROP USER


© Copyright SS64.com 1999-2014
Some rights reserved