Updated on 2026-08-25 GMT+08:00

Deleting a Database Object

Function

This API is used to delete a database object.

Authorization Information

Each account has permissions to call all APIs, but IAM users must have the required permissions specifically assigned.

If you are using role/policy-based authorization, see the required permissions in Permissions Policies and Supported Actions.
If you are using identity policy-based authorization, the following identity policy-based permissions are required.

Action

Access Level

Resource Type (*: required)

Condition Key

Alias

Dependencies

das:connection:delete

Write

connection

-

das:connections:delete

-

Action	Access Level	Resource Type (*: required)	Condition Key	Alias	Dependencies
das:connection:delete	Write	connection	-	das:connections:delete	-

URI

DELETE /v3/{project_id}/connections/{connection_id}/delete-db-obj

**Table 1** URI parameters
Parameter	Mandatory	Type	Description
project_id	Yes	String	Definition Project ID of a tenant in a region. To obtain this value, see Obtaining a Project ID. Constraints N/A Range The value can contain 32 characters. Only letters and digits are supported. Default Value N/A
connection_id	Yes	String	Definition Connection ID established between a database account and the database. The database user ID is created using the API in Creating an Instance Connection. Constraints N/A Range The value is a UUID containing 36 characters. Only letters, digits, and hyphens (-) are allowed. Default Value N/A

**Table 2** Query parameters
Parameter	Mandatory	Type	Description
db_name	Yes	String	Definition Database name Constraints N/A Range N/A Default Value N/A
schema_name	No	String	Definition Schema name Constraints N/A Range N/A Default Value N/A
table_name	No	String	Definition Table name Constraints This parameter is mandatory when obj_type is set to column, generated_column, key, or foreign. Range N/A Default Value N/A
obj_name	No	String	Definition Object name Constraints N/A Range N/A Default Value N/A
obj_id	No	String	Definition Object ID Constraints N/A Range N/A Default Value N/A
obj_type	Yes	String	Definition Object type Constraints N/A Range database schema table view trigger event function procedure column generated_column key foreign Default Value N/A

Request Parameters

None

Response Parameters

None

Example Requests

DELETE https://das.cn-north-1.myhuaweicloud.com/v3/054e292c9880d4992f02c0196d3ea468/connections/179e525e-0e9c-4dcc-9dd7-ee2f36121e23/delete-db-obj?db_name=test_db&obj_name=test_tb&table_name=test_tb&obj_type=table

Example Responses

Status code: 200

Success.

Status Codes

Status Code	Description
200	Success.
400	Client error.
500	Server error.

Error Codes

See Error Codes.

Parent topic: Intelligent O&M