检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
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.
REFRESH MATERIALIZED VIEW [ view_name ]; Delete a materialized view. DROP MATERIALIZED VIEW [ view_name ]; Query a materialized view.
the fast-refresh materialized view. gaussdb=#DROP MATERIALIZED VIEW my_imv; -- Delete the my_table table. gaussdb=#DROP TABLE my_table; Helpful Links ALTER MATERIALIZED VIEW, CREATE INCREMENTAL MATERIALIZED VIEW, CREATE MATERIALIZED VIEW, CREATE TABLE, DROP MATERIALIZED VIEW, and
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: A
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: A
Do not add, delete, or modify system catalogs because doing so will result in exceptions or even database unavailability. For details about column types in system catalogs and system views, see Data Types.
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.
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
RESTRICT: refuses to delete the view if any objects depend on it. This is the default action.
RESTRICT: refuses to delete the view if any objects depend on it. This is the default action.
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.
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
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
the table. gaussdb=#DROP TABLE tpcds.reason; -- Delete the schema. gaussdb=#DROP SCHEMA tpcds CASCADE; Helpful Links COMMIT | END, ROLLBACK, and SET TRANSACTION Parent topic: S
Partition operations Add, delete, and truncate partitions, enable or disable row movement, and invalidate partitioned indexes.
