检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
You may use this statement to delete a specific user's connections to a specified database. Precautions GaussDB does not support specified nodes and supports only TO ALL. This function can be used to clear the normal connections that are being used only in force mode.
Precautions LOAD DATA requires the INSERT and DELETE permissions on tables. When the enable_copy_server_files parameter is disabled, only the initial user is allowed to execute LOAD DATA.
On the Authentication Configurations tab, locate the target configuration and click Delete in the Operation column. Figure 1 Deleting a client authentication configuration In the displayed dialog box, enter DELETE and click OK.
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.
Deleting a Client Access Authentication Configuration Function This API is used to delete the client access authentication configuration of an instance. Before calling this API: Learn how to authenticate this API. Obtain the required region and endpoint.
DROP USER MAPPING Description DROP USER MAPPING is used to delete the user mapping from a user to a foreign server.
Deleting a Parameter Template Function This API is used to delete a parameter template. Before calling this API: Learn how to authenticate this API. Obtain the required region and endpoint. Debugging You can debug this API in API Explorer.
Deleting a Scheduled Task Record Function This API is used to delete a scheduled task record. Before calling this API: Learn how to authenticate this API. Obtain the required region and endpoint. Debugging You can debug this API in API Explorer.
Deleting a Manual Backup Function This API is used to delete a manual backup. Before calling this API: Learn how to authenticate this API. Obtain the required region and endpoint. Debugging You can debug this API in API Explorer.
Deleting a SQL Throttling Task (v3.1) Function This API is used to delete a throttling task based on the task ID. Before calling this API: Learn how to authenticate this API. Obtain the required region and endpoint. Debugging You can debug this API in API Explorer.
URI DELETE /v3/{project_id}/instances/{instance_id}/sharding Table 1 Parameter description Parameter Mandatory Type Description project_id Yes String Definition Project ID of a tenant in a region. To obtain the value, see Obtaining a Project ID.
You may use this statement to delete a specific user's connections to a specified database. Precautions GaussDB does not support specified nodes and supports only TO ALL. This function can be used to clear the normal connections that are being used only in force mode.
DBE_SQL_UTIL.drop_sql_patch drop_sql_patch is an interface function used to delete SQL patches. It returns whether the execution is successful. Only the initial user, sysadmin, opradmin, and monadmin have the permission to invoke this interface.
DROP RESOURCE LABEL Description DROP RESOURCE LABEL is used to delete resource labels. The current version does not support this syntax. Precautions Only users with the POLADMIN or SYSADMIN permission, or the initial user can perform this operation.
You can run ALTER TABLE DROP PARTITION to delete any partition from a range partitioned table or list partitioned table. For example, delete the partition date_202005 from the range partitioned table range_sales by specifying the partition name and update the global index.
You can run ALTER TABLE DROP PARTITION to delete any partition from a range partitioned table or list partitioned table. For example, delete the partition date_202005 from the range partitioned table range_sales by specifying the partition name and update the global index.
statements (unit: μs). max_delete_elapse bigint Maximum response time of DELETE statements (unit: μs). min_delete_elapse bigint Minimum response time of DELETE statements (unit: μs). avg_delete_elapse bigint Average response time of DELETE statements (unit: μs).
GaussDB does not delete or perform any operations on any user data. If this problem occurs, check whether there have been any misoperations and restore the data from backup files, if necessary.
Deleting a Task Record Function This API is used to delete a task record. Before calling this API: Learn how to authenticate this API. Obtain the required region and endpoint. Debugging You can debug this API in API Explorer.
WHERE id1=OLD.id1; RETURN OLD; END $$ LANGUAGE plpgsql; -- Create a DELETE trigger. gaussdb=# CREATE TRIGGER delete_trigger BEFORE DELETE ON test_trigger_src_tbl FOR EACH ROW EXECUTE PROCEDURE tri_delete_func(); -- Execute the DELETE event
