DROP ACCOUNT

Deletes an account. For more information, see Managing accounts.

Syntax

DROP ACCOUNT [ IF EXISTS ] <account_name> [ RESTRICT | CASCADE ];

Parameter	Description
`<account_name>`	The name of the account to delete.
`RESTRICT \| CASCADE`	An optional parameter to specify deletion mode. RESTRICT mode prevents dropping the account if there is any sub-object contained in the account. By default, if the account contains no objects, it will just be dropped. CASCADE mode automatically drops the account and all the sub-objects it contains (databases, engines, users, roles, etc.).

All engines in your accounts must be in a stopped state before running the DROP ACCOUNT … CASCADE statement.

The following command will delete the “dev” account.

DROP ACCOUNT dev

⌘I