DROP ACCOUNTΒΆ

Drops an account, which initiates the process of deleting the account.

See also:

CREATE ACCOUNT, SHOW ACCOUNTS, UNDROP ACCOUNT

SyntaxΒΆ

DROP ACCOUNT [ IF EXISTS ] <name> GRACE_PERIOD_IN_DAYS = <integer>
Copy

ParametersΒΆ

name

Specifies the name of the account being dropped. As an example, if the full account identifier is myorg-account123, then specify account123 as the name. If you do not know the account name, execute the SHOW ACCOUNTS command, and find the name in the account_name column.

The legacy account locator cannot be used to identify the account.

GRACE_PERIOD_IN_DAYS = integer

Specifies the number of days during which the account can be restored (β€œundropped”). The minimum is 3 days and the maximum is 90 days.

Usage notesΒΆ

  • Only organization administrators (i.e. a user with the ORGADMIN role) can execute the command.

  • The organization administrator cannot drop the account they are currently logged in to.

ExampleΒΆ

To drop an account my_account and allow a 14-day grace period for restoring the account, enter:

DROP ACCOUNT my_account GRACE_PERIOD_IN_DAYS = 14;
Copy