检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
FOR SHARE/UPDATE is used to lock rows in a transaction, other transactions cannot modify or delete these rows. When FOR SHARE is used to lock a row, the current transaction and other transactions cannot modify or delete the locked row.
-- Delete the view resource label view_for_label. gaussdb=# DROP VIEW view_for_label; -- Delete the schema resource label schema_for_label. gaussdb=# DROP SCHEMA schema_for_label; -- Delete the tb_for_label table. gaussdb=# DROP TABLE tb_for_label; Helpful Links ALTER RESOURCE
a masking policy. gaussdb=# DROP MASKING POLICY IF EXISTS maskpol1; -- Delete a group of masking policies. gaussdb=# DROP MASKING POLICY IF EXISTS maskpol2, maskpol3; -- Delete a resource label. gaussdb=# DROP RESOURCE LABEL mask_lb1; gaussdb=# DROP RESOURCE LABEL mask_lb2; gaussdb
a masking policy. gaussdb=# DROP MASKING POLICY IF EXISTS maskpol1; -- Delete a group of masking policies. gaussdb=# DROP MASKING POLICY IF EXISTS maskpol2, maskpol3; -- Delete a resource label. gaussdb=# DROP RESOURCE LABEL mask_lb1; gaussdb=# DROP RESOURCE LABEL mask_lb2; gaussdb
If you fail to delete an object by specifying its name after truncation, specify its original name to delete it, or manually delete it from the system catalogs on each node.
RESTRICT Refuses to delete the aggregate function if any objects depend on it. This is a default processing.
Value range: an existing database name Examples -- Create a database. gaussdb=# CREATE DATABASE testdb1; -- Delete the database. gaussdb=# DROP DATABASE testdb1; Helpful Links CREATE DATABASE Suggestions DROP DATABASE Do not delete databases during transactions. Parent topic: D
RESTRICT: refuses to delete a materialized view if any objects depend on it. This is the default value.
RESTRICT: refuses to delete the materialized view if any objects depend on it. This is the default action.
RESTRICT: refuses to delete the materialized view if any objects depend on it. This is the default action.
RESTRICT: refuses to delete a materialized view if any objects depend on it. This is the default value.
the fast-refresh materialized view. gaussdb=# DROP MATERIALIZED VIEW my_imv; -- Delete the complete-refresh materialized view. gaussdb=# DROP MATERIALIZED VIEW my_mv; -- Delete the my_table table. gaussdb=# DROP TABLE my_table; Helpful Links ALTER MATERIALIZED VIEW, CREATE INCREMENTAL
a fast-refresh materialized view. gaussdb=# DROP MATERIALIZED VIEW my_imv; -- Delete a complete-refresh materialized view. gaussdb=# DROP MATERIALIZED VIEW my_mv; -- Delete the my_table table. gaussdb=# DROP TABLE my_table; Helpful Links ALTER MATERIALIZED VIEW, CREATE INCREMENTAL
the fast-refresh materialized view. openGauss=# DROP MATERIALIZED VIEW my_imv; -- Delete the complete-refresh materialized view. openGauss=# DROP MATERIALIZED VIEW my_mv; -- Delete the my_table table. openGauss=# DROP TABLE my_table; Helpful Links ALTER MATERIALIZED VIEW, CREATE
the fast-refresh materialized view. openGauss=# DROP MATERIALIZED VIEW my_imv; -- Delete the complete-refresh materialized view. openGauss=# DROP MATERIALIZED VIEW my_mv; -- Delete the my_table table. openGauss=# DROP TABLE my_table; Helpful Links ALTER MATERIALIZED VIEW, CREATE
a fast-refresh materialized view. gaussdb=# DROP MATERIALIZED VIEW my_imv; -- Delete a complete-refresh materialized view. gaussdb=# DROP MATERIALIZED VIEW my_mv; -- Delete the my_table table. gaussdb=# DROP TABLE my_table; Helpful Links ALTER MATERIALIZED VIEW, CREATE INCREMENTAL
a fast-refresh materialized view. gaussdb=# DROP MATERIALIZED VIEW my_imv; -- Delete a complete-refresh materialized view. gaussdb=# DROP MATERIALIZED VIEW my_mv; -- Delete the my_table table. gaussdb=# DROP TABLE my_table; Helpful Links ALTER MATERIALIZED VIEW, CREATE INCREMENTAL
Examples 1 2 3 4 5 -- Delete a masking policy. gaussdb=# DROP MASKING POLICY IF EXISTS maskpol1; -- Delete a group of masking policies. gaussdb=# DROP MASKING POLICY IF EXISTS maskpol1, maskpol2, maskpol3; Helpful Links ALTER MASKING POLICY and CREATE MASKING POLICY Parent topic
Examples 1 2 3 4 5 -- Delete a resource label. gaussdb=# DROP RESOURCE LABEL IF EXISTS res_label1; -- Delete a group resource label. gaussdb=# DROP RESOURCE LABEL IF EXISTS res_label1, res_label2, res_label3; Helpful Links ALTER RESOURCE LABEL and CREATE RESOURCE LABEL Parent topic
Examples 1 2 3 4 5 -- Delete a masking policy. gaussdb=# DROP MASKING POLICY IF EXISTS maskpol1; -- Delete a group of anonymization policies. gaussdb=# DROP MASKING POLICY IF EXISTS maskpol1, maskpol2, maskpol3; Helpful Links ALTER MASKING POLICY and CREATE MASKING POLICY Parent
