Deleting a Database (RDS for SQL Server)

Function

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

• Before calling an API, you need to understand the API in Authentication.
• Before calling this API, learn about request header parameters.

Constraints

This operation cannot be performed when the DB instance is in any of the following statuses: creating, changing instance class, changing port, 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	Explanation: Project ID of a tenant in a region. For details about how to obtain the project ID, see Obtaining a Project ID. Constraints: N/A Value range: N/A Default value: N/A
  instance_id	Yes	Explanation: Instance ID. Constraints: N/A Value range: N/A Default value: N/A
  db_name	Yes	Explanation: Name of the database to be deleted.

Request

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	Explanation: Job ID. Value range: N/A

• Example normal response

  { 
    "job_id" : "e7a7535b-eb9b-45ac-a83a-020dc5016d94" 
  }

• Abnormal response

  For details, see Abnormal Request Results.

Status Code

• Normal

  200

• Abnormal

  For details, see Status Codes.

Error Code

For details, see Error Codes.