检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Examples 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 -- Delete all employees in a department from the EMP table. If the department has no employees, delete the department from the DEPT table.
Use either of the following two methods to recreate an index: Run the DROP INDEX statement to delete the index and run the CREATE INDEX statement to create an index. Delete an index. DROP INDEX areaS_idx; DROP INDEX Create an index.
Delete the index before the import.
Delete Locate a query filter and click Delete in the Operation column to delete the filter. Click OK. Parent Topic: GaussDB(DWS) Resource Load Management
To delete the manual snapshots, log in to the GaussDB(DWS) management console and go to the Clusters page.
Handling Procedure When creating a GDS foreign table, delete the specified distribution information, that is, delete the specified DISTRIBUTE BY ROUNDROBIN in the statement. Parent topic: Data Import and Export
Solution: Delete the abnormal CN, and then delete other CNs. Parent topic: GAUSS-52000 -- GAUSS-52999
GAUSS-00289: "RETURNING cannot contain references to other relations" SQLSTATE: 0A000 Description: The incorrect RETURNING clause in the INSERT/UPDATE/DELETE syntax references another relational table. Solution: Delete the reference on the relational table.
CASCADE | RESTRICT Specifies how to process related data in the dependent object when a delete operation is performed. CASCADE: automatically deletes objects (such as views) that depend on the table to be deleted.
GS_WORKLOAD_SQL_COUNT GS_WORKLOAD_SQL_COUNT displays statistics on the number of SQL statements executed in workload Cgroups on the current node, including the number of SELECT, UPDATE, INSERT, and DELETE statements and the number of DDL, DML, and DCL statements.
GLOBAL_WORKLOAD_SQL_COUNT GLOBAL_WORKLOAD_SQL_COUNT displays statistics on the number of SQL statements executed in all workload Cgroups in a cluster, including the number of SELECT, UPDATE, INSERT, and DELETE statements and the number of DDL, DML, and DCL statements.
GS_WORKLOAD_SQL_COUNT GS_WORKLOAD_SQL_COUNT displays statistics on the number of SQL statements executed in workload Cgroups on the current node, including the number of SELECT, UPDATE, INSERT, and DELETE statements and the number of DDL, DML, and DCL statements.
GLOBAL_WORKLOAD_SQL_COUNT GLOBAL_WORKLOAD_SQL_COUNT displays statistics on the number of SQL statements executed in all workload Cgroups in a cluster, including the number of SELECT, UPDATE, INSERT, and DELETE statements and the number of DDL, DML, and DCL statements.
CASCADE | RESTRICT Specifies how to process related data in the dependent object when a delete operation is performed. CASCADE: automatically deletes all objects that depend on the index to be deleted. RESTRICT (default): refuses to delete the index if any objects depend on it.
RESTRICT (default): refuses to delete the table if any objects depend on it. This is the default. Examples Delete the warehouse_t1 table: 1 DROP TABLE tpcds.warehouse_t1; Links ALTER TABLE, 12.101-RENAME TABLE, and CREATE TABLE Parent Topic: DDL Syntax
Data migration dataMigrationDeleteCluster Normal Start to delete the data migration instance. Data migration dataMigrationDeleteClusterApplication Normal Start to delete the job task. Data migration dataMigrationDeleteClusterApplicationFailed Warning Failed to delete the job.
Precautions The user must have the DROP permission in order to delete a resource pool.
Delete Click Delete in the Operation column of a SQL probe. In the displayed dialog box, enter DELETE or click Auto Enter. Click OK. Parent Topic: Viewing GaussDB(DWS) Cluster Monitoring Information on the Monitoring Panel (DMS)
PGXC_WORKLOAD_SQL_COUNT PGXC_WORKLOAD_SQL_COUNT displays statistics on the number of SQL statements executed in workload Cgroups on all CNs in a cluster, including the number of SELECT, UPDATE, INSERT, and DELETE statements and the number of DDL, DML, and DCL statements.
RESTRICT Refuses to delete the type if any objects depend on it. This is the default. Examples Delete the compfoo type: 1 DROP TYPE compfoo cascade; Links ALTER TYPE, CREATE TYPE Parent Topic: DDL Syntax
