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