检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
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 the server owner can delete a server.
Precautions Only a sequence owner or a system administrator can delete a sequence.
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.
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
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.
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.
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.
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.
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.
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.
