DROP ACCOUNT

Deletes an account.

For more information, see Managing accounts.

Syntax

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

Parameters

Parameter Description
<account_name> The name of the account to delete.
RESTRICT or 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.

Example

The following command will delete the “dev” account.

DROP ACCOUNT dev