Help Center/ Relational Database Service/ API Reference/ API v3.1 (Recommended)/ Deleting a Database (RDS for SQL Server)
Updated on 2025-08-20 GMT+08:00

Deleting a Database (RDS for SQL Server)

Function

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

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.1/{project_id}/instances/{instance_id}/database/{db_name}

  • Parameter description
    Table 1 Parameters

    Parameter

    Mandatory

    Description

    project_id

    Yes

    Definition

    Project ID of a tenant in a region.

    To obtain the value, see Obtaining a Project ID.

    Constraints

    N/A

    Range

    N/A

    Default Value

    N/A

    instance_id

    Yes

    Definition

    Instance ID.

    Constraints

    N/A

    Range

    N/A

    Default Value

    N/A

    db_name

    Yes

    Definition

    Name of the database to be deleted.

Request

Table 2 Parameters

Parameter

Mandatory

Type

Description

is_force_delete

No

Boolean

Definition

Whether to forcibly delete the database.

Constraints

N/A

Range

  • true: The database is forcibly deleted.
  • false: The database is not forcibly deleted.

Default Value

false

Example Request

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

{
   "is_force_delete" : false 
 }

Response

  • Normal response
    Table 3 Parameters

    Parameter

    Type

    Description

    job_id

    String

    Definition

    Job ID.

    Range

    N/A

  • Example normal response
    { 
      "job_id" : "e7a7535b-eb9b-45ac-a83a-020dc5016d94" 
    }
  • Abnormal response

    For details, see Abnormal Request Results.

Status Code

Error Code

For details, see Error Codes.