DROP LOGIN

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

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

ALTER LOGIN

CREATE SERVICE ACCOUNT

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

Syntax

Parameters

Example

​Syntax

​Parameters

​Example

Syntax

Parameters

Example