Deletes a login.

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

ParameterDescription
<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";