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