Skip to main content
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="[email protected]"|DEFAULT or the user dropped.

​
Parameters

ParameterDescription
<login_name>The name of the login to delete.

​
Example

The following command will delete the “[email protected]” login. 
DROP LOGIN "[email protected]";