DROP MILESTONE
This command deletes a milestone of a currently attached database.
Syntax
DROP MILESTONE <milestone_name> [FOR database_name];
Remarks
<milestone_name>
is the name of an existing milestone to be dropped.If the
database_name
is not specified, the context database (specified with the USE command) is used.This command will delete the milestone file from the remote database.
Milestones with reserved names such as "_first_milestone" and the milestone created during a restore into bottomless storage cannot be dropped.
Example
The following example drops a milestone "m
" on the existing unlimited storage database bottomless_db
:
DROP MILESTONE "m" FOR bottomless_db;