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.

Examples

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 © 1999-2024 SS64.com
Some rights reserved