检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
the reason and reason_t1 tables. gaussdb=# DROP TABLE tpcds.reason; gaussdb=# DROP TABLE tpcds.reason_t1; -- Delete the schema. gaussdb=# DROP SCHEMA tpcds CASCADE; Parent topic: SQL Syntax
You can also manually run gs_clean -C to delete inactive session data from the table. Data is automatically inserted into PLAN_TABLE_DATA after EXPLAIN PLAN is executed. Therefore, do not manually insert data into or update data in PLAN_TABLE_DATA.
a fast-refresh materialized view. gaussdb=# DROP MATERIALIZED VIEW my_imv; -- Delete the ordinary table my_table. gaussdb=# DROP TABLE my_table; -- Delete the tablespace. gaussdb=# DROP TABLESPACE tbs_data1; Helpful Links ALTER MATERIALIZED VIEW, CREATE MATERIALIZED VIEW, CREATE
the complete-refresh materialized view. gaussdb=# DROP MATERIALIZED VIEW my_mv; -- Delete the ordinary table my_table. gaussdb=# DROP TABLE my_table; -- Delete the tablespace. gaussdb=# DROP TABLESPACE tbs_data1; Helpful Links ALTER MATERIALIZED VIEW, CREATE INCREMENTAL MATERIALIZED
GaussDB supports the access of content in an array by using parentheses, and the extend, count, first, last prior, next, exists, trim, and delete functions.
the user mapping. gaussdb=# DROP USER MAPPING FOR bob SERVER my_server; -- Delete the foreign server. gaussdb=# DROP SERVER my_server; -- Delete the role. gaussdb=# DROP ROLE bob; Helpful Links ALTER USER MAPPING and DROP USER MAPPING Parent topic: C
the user mapping. gaussdb=# DROP USER MAPPING FOR bob SERVER my_server; -- Delete the foreign server. gaussdb=# DROP SERVER my_server; -- Delete the role. gaussdb=# DROP ROLE bob; Helpful Links CREATE USER MAPPING and DROP USER MAPPING Parent topic: A
There are three scenarios: COORDINATOR: Delete the idle or invalid connections from the current CN to a specified CN. NODE: Delete the idle or invalid connections from the current CN to a specified DN.
If you delete a parameter that does not exist, an error will be reported. Examples See Examples. Helpful Links ALTER GLOBAL CONFIGURATION Parent topic: D
If you delete a parameter that does not exist, an error will be reported. Helpful Links ALTER GLOBAL CONFIGURATION Parent topic: SQL Syntax
If you delete a parameter that does not exist, an error will be reported. Helpful Links ALTER GLOBAL CONFIGURATION Parent topic: SQL Syntax
UPDATE, DELETE, and INSERT automatically acquire this lock on the target table and add the ACCESS SHARE lock to other referenced tables. Generally, all statements that modify table data acquire the ROW EXCLUSIVE lock for tables.
Figure 5 Modifying a throttling task To delete a throttling task, click Delete in the Operation column of the task.
You can delete a partition by specifying the partition name or partition value. This command cannot be applied to hash partitions. Running this command will invalidate the global index.
SUMMARY_WORKLOAD_SQL_COUNT columns Name Type Description node_name name Node name. 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
SUMMARY_WORKLOAD_SQL_COUNT columns Name Type Description node_name name Node name 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
SUMMARY_WORKLOAD_SQL_COUNT columns Name Type Description node_name name Node name. 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
SUMMARY_WORKLOAD_SQL_COUNT columns Name Type Description node_name name Node name 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
To delete an existing user, use DROP USER. To change a user account (for example, rename the user or change the password), use ALTER USER.
To delete an existing user, use DROP USER. To change a user account (for example, rename the user or change the password), use ALTER USER.
