Help Center/ Relational Database Service/ API Reference/ Historical APIs/ API v3/ Deleting a Database (RDS for SQL Server)
Updated on 2024-04-01 GMT+08:00

Deleting a Database (RDS for SQL Server)

Function

This API is used to delete a database from a specified DB instance.

This API will be unavailable on March 31, 2025. You are advised to switch workloads to the new API (Deleting a Database (RDS for SQL Server)) before then.

  • Before calling an API, you need to understand the API in Authentication.

Constraints

This operation cannot be performed when the DB instance is in any of the following statuses: creating, changing instance class, changing port, frozen, or abnormal.

URI

  • URI format

    DELETE /v3/{project_id}/instances/{instance_id}/database/{db_name}

  • Parameter description
    Table 1 Parameter description

    Name

    Mandatory

    Description

    project_id

    Yes

    Specifies the project ID of a tenant in a region.

    For details about how to obtain the project ID, see Obtaining a Project ID.

    instance_id

    Yes

    Specifies the DB instance ID.

    db_name

    Yes

    Specifies the name of the database to be deleted.

Request

Parameter description
Table 2 Parameter description

Name

Mandatory

Type

Description

is_force_delete

No

Boolean

Specifies whether to forcibly delete a database. The default value is false.

Example Request

https://{endpoint}/v3/0483b6b16e954cb88930a360d2c4e663/instances/a8abe84a41364097be7c233c39275087in04/database/rds-test

{
  "is_force_delete" : false
}

Response

  • Normal response
    Table 3 Parameter description

    Name

    Type

    Description

    resp

    String

    Returns successful if the invoking is successful.

Status Code

Error Code

For details, see Error Codes.