检测到您已登录华为云国际站账号,为了您更好的体验,建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Common partition tables do not automatically create new partitions or delete expired partitions. Therefore, maintenance personnel need to periodically create new partitions and delete expired partitions, leading to increased O&M costs.
RESTRICT: refuses to delete the synonym if any objects depend on it. This is the default. Examples Delete synonyms: 1 DROP SYNONYM t1; Helpful Links ALTER SYNONYM and CREATE SYNONYM Parent Topic: DDL Syntax
Elastically Adding or Deleting a Logical Cluster Context You can add or delete VMs manually or automatically. Computing logical clusters can be created and deleted during the scheduled period of time to dynamically scale computing resources.
GAUSS-02363: "failed to fetch deleted tuple for DELETE RETURNING" SQLSTATE: XX000 Description: Failed to obtain the deleted tuple using DELETE RETURNING.
Deleting Cross-Region Backup Configurations Function This API is used to delete cross-region backup configurations. Call Method For details, see Calling APIs.
Delete the manually created foreign server. Run the following command to delete the server.
Delete the created foreign server.
Precautions To delete an overloaded function, you must specify the function's parameter (argument) type. For non-overloaded functions, you can delete them by just specifying the function name.
The differences between TRUNCATE, DELETE, and DROP are as follows: TRUNCATE TABLE deletes content, releases space, but does not delete definitions. DELETE TABLE deletes content, but does not delete definitions nor release space.
If you do not delete the cluster manually, the system will charge you for that cluster. To avoid additional fees, log in to the GaussDB(DWS) management console and go to the Clusters page to delete your cluster if you do not want to use it after the trial period ends.
The differences between TRUNCATE, DELETE, and DROP are as follows: TRUNCATE TABLE deletes content, releases space, but does not delete definitions. DELETE TABLE deletes content, but does not delete definitions nor release space.
ON COMMIT DELETE ROWS is also not supported and will be migrated to ON COMMIT PRESERVE ROWS. The following is an example of the syntax of a temporary table before and after migration.
Precautions Similar to column storage, the UPDATE operation on an HStore table in the current version involves DELETE and INSERT. You can configure a global GUC parameter to control the lightweight UPDATE of HStore.
Locate the row that contains the tag to be deleted, click Delete in the Operation column. The Delete Tag dialog box is displayed. After confirming that the information is correct, enter DELETE or click Auto Enter and click OK to delete the tag.
Deleting CN Nodes in Batches Function This API is used to delete CNs from a specified cluster. After a cluster is created, the number of required CNs varies with service requirements. The CN management function enables you to adjust the number of CNs in the cluster.
Deleting Clusters Function This API is used to delete clusters. All resources of the deleted cluster, including user data, will be released. For data security, create a snapshot for the cluster that you want to delete before deleting the cluster.
DSC will delete the keyword during migration. Input 1 2 3 4 5 6 CREATE TABLE `public`.
Locate the row that contains the tag to be deleted, click Delete in the Operation column. The Delete Tag dialog box is displayed. Click Yes to delete the tag. Parent topic: Managing Tags
DSC will delete the attribute during migration. In MySQL, the keyword CONNECTION is used as a referenced, external data source. Currently, DSC cannot completely migrate the feature of CONNECTION. So as a workaround, it simply deletes the keyword.
Deleting a Resource Management Plan Function This API is used to delete a resource management plan. Call Method For details, see Calling APIs.