# DROP MILESTONE

The `DROP MILESTONE` 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;
```

***

Modified at: June 11, 2026

Source: [/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-milestone/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-milestone/)

(An index of the documentation is available at /llms.txt)