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;