检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
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
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: 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.
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 reason and reason_t1 tables. m_db=# DROP TABLE tpcds.reason; m_db=# DROP TABLE tpcds.reason_t1; -- Delete the schema. m_db=# DROP SCHEMA tpcds; Parent topic: E
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. m_db=# DROP RESOURCE LABEL table_label; -- Delete the base table table_for_label. m_db=# DROP TABLE table_for_label; Helpful Links CREATE RESOURCE LABEL and DROP RESOURCE LABEL Parent topic: A
Global temporary tables can be created using ON COMMIT PRESERVE ROWS or ON COMMIT DELETE ROWS.
Delete user jack. 1 2 gaussdb=# DROP USER jack CASCADE; DROP ROLE Delete tables foo and foo2. 1 2 gaussdb=# DROP TABLE foo; gaussdb=# DROP TABLE foo2; If the following information is displayed, the operation is successful: 1 DROP TABLE Delete tablespace fspace. 1 2 gaussdb=# DROP
1 DROP TABLE Run the following command to delete tablespace fspace: 1 2 openGauss=# DROP TABLESPACE fspace; DROP TABLESPACE Only the tablespace owner or system administrator can delete a tablespace.
a masking policy. gaussdb=# DROP MASKING POLICY maskpol1; -- Delete resource labels. gaussdb=# DROP RESOURCE LABEL mask_lb1, mask_lb2; - Delete the tb_for_masking table. gaussdb=# DROP TABLE tb_for_masking; -- Delete the dev_mask and bob_mask users. gaussdb=# DROP USER dev_mask
a masking policy. gaussdb=# DROP MASKING POLICY maskpol1; -- Delete resource labels. gaussdb=# DROP RESOURCE LABEL mask_lb1, mask_lb2; -- Delete the tb_for_masking table. gaussdb=# DROP TABLE tb_for_masking; -- Delete the dev_mask and bob_mask users. gaussdb=# DROP USER dev_mask
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.
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
Partition operations Add, delete, and truncate partitions, enable or disable row movement, and invalidate partitioned indexes.
