检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
the aggregate function. gaussdb=# DROP AGGREGATE sum_add(int); -- Delete the user-defined function. gaussdb=# DROP FUNCTION int_add(int,int); -- Delete the test table. gaussdb=# DROP TABLE test_sum; Helpful Links ALTER AGGREGATE and DROP AGGREGATE Parent topic: C
the policy. gaussdb=# DROP ROW LEVEL SECURITY POLICY all_data_new_rls ON all_data; -- Delete users alice and bob. gaussdb=# DROP ROLE alice, bob; -- Delete the all_data table. gaussdb=# DROP TABLE all_data; Helpful Links CREATE ROW LEVEL SECURITY POLICY and DROP ROW LEVEL SECURITY
*/ exec sql open cur1; exec sql fetch 1 in cur1 into :va, :vb; printf("c1:%d, c2:%d\n", va, vb); /* Use the WHERE CURRENT OF clause to delete the current line. */ exec sql delete t1 where current of cur1; exec sql fetch 1 in cur1 into :va, :vb; exec sql
It must be unique in the session. data_type Specifies the type of an argument. statement Specifies a SELECT, INSERT, UPDATE, DELETE, MERGE INTO, or VALUES statement. Examples For details, see Examples. Helpful Links DEALLOCATE and EXECUTE Parent topic: P
Table 1 WORKLOAD_SQL_COUNT columns Name Type Description workload name Workload name. select_count bigint Number of SELECT statements. update_count bigint Number of UPDATE statements. insert_count bigint Number of INSERT statements. delete_count bigint Number of DELETE statements.
value can be access or privilege. access: DML operations are audited. privilege: DDL operations are audited. polenabled Boolean Specifies whether the policy is enabled. t (true): enabled. f (false): disabled. access_type name DML database operation types, such as SELECT, INSERT, and DELETE
D DEALLOCATE DECLARE DELETE DO DROP AGGREGATE DROP AUDIT POLICY DROP CAST DROP CLIENT MASTER KEY DROP COLUMN ENCRYPTION KEY DROP DATABASE DROP DATABASE LINK DROP DIRECTORY DROP EVENT DROP EXTENSION DROP FOREIGN DATA WRAPPER DROP FOREIGN TABLE DROP FUNCTION DROP GLOBAL CONFIGURATION
It must be unique in the session. data_type Specifies the type of an argument. statement Specifies a SELECT, INSERT, UPDATE, DELETE, MERGE INTO, or VALUES statement. Examples See Examples. Helpful Links DEALLOCATE and EXECUTE Parent topic: P
Value range: access: DML operations are audited. privilege: DDL operations are audited. polenabled Boolean Specifies whether to enable a policy. t (true): enabled. f (false): disabled. access_type name DML database operation types, such as SELECT, INSERT, and DELETE, or DDL database
on the actual situation. gaussdb=# ALTER TABLE table_name SET (parallel_workers=4); -- Create an index. gaussdb=# CREATE INDEX index_name ON table_name(col1); -- Reset the parallel_workers parameter for the table. gaussdb=# ALTER TABLE table_name RESET (parallel_workers); -- Delete
However, you cannot delete or reboot the instances that are being scaled. During CPU and memory specification change, the network is intermittently disconnected for one or two times in seconds. A failover may occur during this period and services may be briefly interrupted.
RESTRICT: refuses to delete the view if any objects depend on it. This is the default action. Examples See Examples in section "CREATE VIEW." Helpful Links ALTER VIEW and CREATE VIEW Parent topic: SQL Syntax
It must be unique in the session. data_type Specifies the type of an argument. statement Specifies a SELECT, INSERT, UPDATE, DELETE, MERGE INTO, or VALUES statement. Examples See Examples in section "EXECUTE." Helpful Links DEALLOCATE Parent topic: SQL Syntax
Helpful Links ALTER TABLESPACE and CREATE TABLESPACE Suggestions DROP TABLESPACE Do not delete tablespaces during transactions. Parent topic: SQL Syntax
RESTRICT: refuses to delete the view if any objects depend on it. This is the default action. Examples See Examples in section "CREATE VIEW." Helpful Links ALTER VIEW and CREATE VIEW Parent topic: SQL Syntax
RESTRICT: refuses to delete the view if any objects depend on it. This is the default action. Examples See Examples in CREATE VIEW. Helpful Links ALTER VIEW and CREATE VIEW Parent topic: SQL Syntax
It must be unique in the session. data_type Specifies the type of an argument. statement Specifies a SELECT, INSERT, UPDATE, DELETE, MERGE INTO, or VALUES statement. Examples See Examples in "EXECUTE." Helpful Links DEALLOCATE Parent topic: SQL Syntax
Helpful Links ALTER TABLESPACE and CREATE TABLESPACE Suggestions drop tablespace Do not delete tablespaces during transactions. Parent topic: SQL Syntax
Helpful Links CREATE DATABASE Suggestions drop database Do not delete databases during transactions. Parent topic: SQL Syntax
Helpful Links ALTER TABLESPACE and CREATE TABLESPACE Suggestions drop tablespace Do not delete tablespaces during transactions. Parent topic: SQL Syntax
