检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Deleting a Resource Management Plan Stage Function This API is used to delete a resource management plan stage. Call Method For details, see Calling APIs.
GAUSS-03801 -- GAUSS-03810 GAUSS-03801: "cannot perform DELETE RETURNING on relation '%s'" SQLSTATE: 0A000 Description: An error occurs when the DELETE RETURNING operation is performed on a table because the INSTEAD rule contains RETURNING while the original statement does not.
Deleting an Automated Snapshot Only GaussDB(DWS) can delete automated snapshots; you cannot delete them manually. GaussDB(DWS) deletes an automated snapshot if: The retention period of the snapshot ends. The cluster is deleted.
GAUSS-03641 -- GAUSS-03650 GAUSS-03641: "failed to delete rightmost child %u of block %u in index '%s'" SQLSTATE: XX000 Description: Failed to delete the node. Solution: An internal error occurs. This is a preventive error mechanism. You can contact technical support.
Deleting a DR Task Function This API is used to delete a DR operation. You can delete a DR task when DR Status is Creation failed, Not started, Startup failed, Stopped, Stop failed, or Abnormal.
Examples Delete a query filtering rule named query_block. 1 2 DROP BLOCK RULE query_block; DROP BLOCK RULE IF EXISTS query_block; Parent Topic: DDL Syntax
DROP DATABASE Function Delete the database. Precautions Only the owner of a database or a system administrator has the permission to run the DROP DATABASE command.
DSC will delete this attribute during migration. Input 1 2 3 4 5 6 7 8 9 CREATE TABLE `public`.
information_schema.columns WHERE TABLE_NAME=lower('TMPO_HXYW_LNSACCTINFO_H1'); if V_CNT>0 then EXECUTE IMMEDIATE 'DROP TABLE TMPO_HXYW_LNSACCTINFO_H1'; end if; END; RETURN O_RETURN; END; / Qualifying Language Migrate the nzplSQL language to the plpgSQL language or delete
Precautions Only a sequence owner or a system administrator can delete a sequence.
Examples Delete the connections of database template1 on the cn_5001 and cn_5002 nodes. 1 CLEAN CONNECTION TO NODE (cn_5001, cn_5002) FOR DATABASE template1; Delete the connection of user jack to the cn_5001 node. 1 CLEAN CONNECTION TO NODE (cn_5001) TO USER jack; Delete all connections
Click Delete Resource Pool. Deleting a resource pool that is associated with a database user is not allowed. To delete the resource pool, you need to first disassociate it from the database user. Parent topic: Resource Pool
Precautions Only the server owner can delete a server.
Precautions Only a sequence owner or a system administrator can delete a sequence.
RESTRICT (default): refuses to delete the server if any objects depend on it. Examples Delete the hdfs_server server: 1 DROP SERVER hdfs_server; Links CREATE SERVER, ALTER SERVER Parent Topic: DDL Syntax
RESTRICT: refuses to delete the synonym if any objects depend on it. This is the default. Examples Delete synonyms: 1 DROP SYNONYM t1; Links ALTER SYNONYM and CREATE SYNONYM Parent Topic: DDL Syntax
Precautions Only the table owner has the permission to delete a data redaction policy.
Precautions Only the table owner or administrators can delete a row-level access control policy from the table.
Precautions Only the table owner or administrators can delete a row-level access control policy from the table.
You may use this statement to delete a specific user's connections to a specified database. Precautions You must specify either dbname or username.
