Deleting a Database

Function

This API is used to delete a database from a specified DB instance. Before calling this API:

Learn how to authenticate this API.
Obtain the required region and endpoint.

Constraints

This API can only be used to delete a single database. This operation cannot be performed when the instance is in any of the following statuses: creating, changing instance specifications, frozen, or abnormal.

URI

DELETE https://{Endpoint}/v3/{project_id}/instances/{instance_id}/database?database_name={database_name}

**Table 1** Parameter description
Parameter	Mandatory	Description
project_id	Yes	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	Instance ID.
database_name	Yes	Database name. The database name can contain 1 to 63 characters, including letters, digits, and underscores (_). It cannot start with pg or a digit, and must be different from template database names. Template databases include postgres, template0, templatem, and template1.

Request Parameters

None

Response Parameters

None

Example Request

Deleting the GaussDB database gaussdb_test

DELETE https://gaussdb-opengauss.ap-southeast-1.myhuaweicloud.com/v3/0483b6b16e954cb88930a360d2c4e663/instances/{instance_id}/database?database_name=gaussdb_test