Help Center/ Distributed Database Middleware/ API Reference/ APIs (Recommended)/ Schemas/ Deleting a Schema
Updated on 2024-08-02 GMT+08:00
View PDF
Share

Deleting a Schema

Function

This API is used to delete a schema to release all its resources.

Constraints

None

URI

DELETE /v1/{project_id}/instances/{instance_id}/databases/{ddm_dbname}?delete_rds_data={delete_rds_data}

Table 1 Path parameters

Parameter

Mandatory

Type

Description

project_id

Yes

String

Project ID

To obtain this value, see Obtaining a Project ID.

instance_id

Yes

String

DDM instance ID

ddm_dbname

Yes

String

Name of the schema to be queried, which is case-insensitive
Table 2 Query parameters

Parameter

Mandatory

Type

Description

delete_rds_data

No

String

Whether data stored on the associated DB instances is deleted. The value can be:

  • true: indicates that the data stored on the associated DB instances is deleted.
  • false: indicates that the data stored on the associated DB instances is not deleted. It is left blank by default.

Enumerated values:

  • true
  • false

Request Parameters

Table 3 Request header parameters

Parameter

Mandatory

Type

Description

X-Auth-Token

Yes

String

User token

You can obtain the token by calling the IAM API used to obtain a user token.

Response Parameters

Status code: 400

Table 4 Response body parameters

Parameter

Type

Description

errCode

String

Service error code

externalMessage

String

Error message

Status code: 500

Table 5 Response body parameters

Parameter

Type

Description

errCode

String

Service error code

externalMessage

String

Error message

Example Request

  • Deleting a schema (including the data stored on associated DB instances) 
    DELETE https://{endpoint}/v1/{project_id}/instances/{instance_id}/databases/{ddm_dbname}?delete_rds_data=true
  • Deleting a schema (excluding the data stored on associated DB instances) 
    DELETE https://{endpoint}/v1/{project_id}/instances/{instance_id}/databases/{ddm_dbname}?delete_rds_data=false

Example Response

Status code: 200

OK

{ }

Status code: 400

bad request

{
  "externalMessage" : "Parameter error.",
  "errCode" : "DBS.280001"
}

Status code: 500

server error

{
  "externalMessage" : "Server failure.",
  "errCode" : "DBS.200412"
}

Status Codes

Status Code

Description

200

OK

400

bad request

500

server error

Error Codes

For details, see Error Codes.

Parent topic: Schemas