检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
REFRESH MATERIALIZED VIEW [ view_name ]; Delete a materialized view. DROP MATERIALIZED VIEW [ view_name ]; Query a materialized view. SELECT * FROM [ view_name ]; Examples -- Prepare data.
REFRESH MATERIALIZED VIEW [ view_name ]; Delete a materialized view. DROP MATERIALIZED VIEW [ view_name ]; Query a materialized view.
the resource label table_label. gaussdb=# DROP RESOURCE LABEL table_label; -- Delete the base table table_for_label. gaussdb=# DROP TABLE table_for_label; Helpful Links CREATE RESOURCE LABEL and DROP RESOURCE LABEL Parent topic: SQL Syntax
Insert, update, and delete rows. Create, replace, modify, and delete objects. Control the access to a database and its objects. Maintain the consistency and integrity of a database. SQL consists of commands and functions that are used to manage databases and database objects.
Insert, update, and delete rows. Create, replace, modify, and delete objects. Control the access to a database and its objects. Maintain the consistency and integrity of a database. SQL consists of commands and functions that are used to manage databases and database objects.
the resource label table_label. gaussdb=# DROP RESOURCE LABEL table_label; -- Delete the base table table_for_label. gaussdb=# DROP TABLE table_for_label; Helpful Links CREATE RESOURCE LABEL and DROP RESOURCE LABEL Parent topic: SQL Syntax
Insert, update, and delete rows. Create, replace, modify, and delete objects. Control the access to a database and its objects. Maintain the consistency and integrity of a database. SQL consists of commands and functions that are used to manage databases and database objects.
DETAIL: Failing row contains (1, 1). gaussdb=# UPDATE vt SET y = 121 WHERE y = 1; UPDATE 1 gaussdb=# UPDATE vt_wco SET y = 6 WHERE y = 11; UPDATE 1 gaussdb=# DELETE FROM vt WHERE y =11; DELETE 0 -- Create a multi-layer nested view and specify WITH CHECK OPTION in the bottom-layer
Database Programming Specifications GUC Parameter Programming Specifications Object Access Programming Specifications WHERE SELECT INSERT UPDATE DELETE Join Query Subquery Transaction SQL Compilation Parent topic: Development and Design Proposal
Database Design Specifications GUC Parameter Programming Specifications Object Access Programming Specifications WHERE SELECT INSERT UPDATE DELETE Join Query Subquery Transaction SQL Compilation Parent topic: Development and Design Proposal
Database Design Specifications GUC Parameter Programming Specifications Object Access Programming Specifications WHERE SELECT INSERT UPDATE DELETE Join Query Subquery Transaction SQL Compilation Parent topic: Development and Design Proposal
Database Programming Specifications GUC Parameter Programming Specifications Object Access Programming Specifications WHERE SELECT INSERT UPDATE DELETE Join Query Subquery Transaction SQL Compilation DDL Parent topic: Development and Design Proposal
You can delete and rebuild the catalogs, add columns to them, and insert and update values in them, but doing so may make system information inconsistent and cause system faults. Generally, users should not modify system catalogs or system views, or rename their schemas.
RESTRICT: refuses to delete the view if any objects depend on it. This is the default action.
a user. gaussdb=# DROP ROLE lche, jim; -- Delete a user group. gaussdb=# DROP GROUP normal_users; Helpful Links CREATE GROUP, DROP GROUP, and ALTER ROLE Parent topic: SQL Syntax
Partition operations Add, delete, and truncate partitions, enable or disable row movement, and invalidate partitioned indexes.
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: SQL Syntax
Delete an encrypted table. gaussdb=# DROP TABLE creditcard_info; DROP TABLE -- 14. Delete a column key. gaussdb=# DROP COLUMN ENCRYPTION KEY cek1; DROP COLUMN ENCRYPTION KEY -- 15.
Delete an encrypted table. gaussdb=# DROP TABLE creditcard_info; DROP TABLE -- 14. Delete a column key. gaussdb=# DROP COLUMN ENCRYPTION KEY cek1; DROP COLUMN ENCRYPTION KEY -- 15.
To delete a cluster node, you only need to connect to one CN. If a cluster node is created on only one CN, to delete the cluster node, you need to define the current CN name and delete the cluster node on the current CN. For details, see DROP NODE.
