ContextQMD
Back to Starrocks

DROP REPOSITORY

docs/en/sql-reference/sql-statements/backup_restore/DROP_REPOSITORY.md

4.1.0828 B
Original Source

DROP REPOSITORY

Deletes a repository. Repositories are used to store data snapshots for data backup and restoration.

CAUTION

  • Only root user and superuser can delete a repository.
  • This operation only deletes the mapping of the repository in StarRocks, and does not delete the actual data. You need to delete it manually in the remote storage system. After deletion, you can map to that repository again by specifying the same remote storage system path.

Syntax

SQL
DROP REPOSITORY <repository_name>

Parameters

ParameterDescription
repository_nameName of the repository to be deleted.

Example

Example 1: deletes a repository named oss_repo.

SQL
DROP REPOSITORY `oss_repo`;