检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Which Should I Delete First, a Schema or its Associated RDS Instances? After an RDS instance is associated with your schema, you cannot delete the instance directly. To delete it, you have to delete the schema first and then delete the instance. Parent topic: DDM Usage
Can I Manually Delete Databases and Accounts Remained in Data Nodes After a Schema Is Deleted? You can delete DDM instances or accounts if they are no longer needed. For details, see Deleting a DDM Instance and Deleting an Account. Parent topic: DDM Usage
Which Should I Delete First, a Schema or its Associated RDS Instances? Can I Manually Delete Databases and Accounts Remained in Data Nodes After a Schema Is Deleted?
Choose Parameter Templates, click the Custom Templates tab, locate the template that you want to delete, and click More > Delete in the Operation column. In the displayed dialog box, click Yes. Parent topic: Parameter Template Management
Deleting a DDM Account Function This API is used to delete a DDM account. This operation will also disassociate the account from schemas if any.
Deleting a DDM instance Scenarios This section describes how to delete a DDM instance by calling an API. For details, see Deleting a DDM Instance. Procedure Delete a DDM instance and delete the data stored in the associated RDS instances.
In the instance list, locate the DDM instance that you want to delete and choose More > Delete in the Operation column. To delete data stored on data nodes, select Delete data on data nodes.
Deleting a DDM Instance Function This API is used to delete a DDM instance to release all its resources.
In the instance list, locate the DDM instance whose DDM account you want to delete and click the instance name. In the navigation pane, choose Accounts. In the account list, locate the account that you want to delete and choose More > Delete in the Operation column.
Your schema will become faulty if you delete its associated data nodes by clicking the Delete button in the schema list. To delete data stored on the associated data nodes, select Delete data on data nodes in the displayed dialog box.
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}?
TRUNCATE TABLE has the DROP permission and can delete all data from a table. In logic, TRUNCATE TABLE is similar to the DELETE statement that can delete all rows from a table.
Example Request This API is used to delete logical sessions of a DDM instance.
Pay-per-Use DDM Instances When you buy a DDM instance billed at a pay-per-use basis, you can delete the instance if it is no longer used.
delete_rds_data=true ddm:instance:delete vpc:ports:delete √ √ The check mark (√) indicates that an action takes effect. The cross mark (x) indicates that an action does not take effect. Parent topic: Permissions Policies and Supported Actions
offset={offset}&limit={limit} ddm:user:list √ √ Modifying a DDM Account PUT /v1/{project_id}/instances/{instance_id}/users/{username} ddm:user:modify √ √ Deleting a DDM Account DELETE /v1/{project_id}/instances/{instance_id}/users/{username} ddm:user:delete √ √ Parent topic: Permissions
Example Request Delete a physical session of a DDM instance.
Association Do not perform an update or delete operation on multiple tables at the same time. Subquery and LIMIT Do not use subqueries in an UPDATE or DELETE statement. Do not use LIMIT or ORDER BY LIMIT in UPDATE or DELETE statements.
delete_rds_data=true ddm:database:delete √ √ Parent topic: Permissions Policies and Supported Actions
DELETE DELETE is used to delete rows that meet conditions from a table. Common Syntax DELETE [IGNORE] FROM tbl_name [WHERE where_condition] Syntax Constraints The WHERE clause does not support subqueries, including correlated and non-correlated subqueries.
