DROP MILESTONE
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
This command deletes a milestone of a currently attached database.
Syntax
DROP MILESTONE <milestone_name> [FOR database_name];
Remarks
-
<milestone_
is the name of an existing milestone to be dropped.name> -
If the
database_
is not specified, the context database (specified with the USE command) is used.name -
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_
:
DROP MILESTONE "m" FOR bottomless_db;
Last modified: March 23, 2022