Link Search Menu Expand Document

DROP LOGIN

Deletes an account.

For more information, see Managing logins.

Syntax

DROP LOGIN [ IF EXISTS ] <login_name> [ RESTRICT | CASCADE ];

Parameters

Parameter Description
<login_name> The name of the login to delete.
RESTRICT or CASCADE An optional parameter to specify deletion mode.
RESTRICT mode prevents dropping the account if there is any user linked to the login.
By default, if the login is not linked to any users, it will just be dropped.
CASCADE mode automatically drops all users linked to the login in all the accounts in the organization.

Example

The following command will delete the “alexs@acme.com” login.

DROP LOGIN "alexs@acme.com";