Drops an account, which initiates the process of deleting the account.
DROP ACCOUNT [ IF EXISTS ] <name> GRACE_PERIOD_IN_DAYS = <integer>
Specifies the name of the account being dropped. As an example, if the full account identifier is
myorg-account123, then specify
account123as the name. If you do not know the account name, execute the SHOW ORGANIZATION ACCOUNTS command, and find the name in the
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.
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.
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;