DROP LOGIN

Deletes an account.

For more information, see Managing logins.

Syntax

DROP LOGIN [ IF EXISTS ] <login_name>;

If the login is linked to a user, it can not be dropped. In order to drop a login linked to a user, the link must be reset alter user foo set login="new-login@acme.com"|DEFAULT or the user dropped.

Parameters

Parameter Description
<login_name> The name of the login to delete.

Example

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

DROP LOGIN "alexs@acme.com";