检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
RESTRICT Refuses to delete the aggregate function if any objects depend on it. This is a default processing.
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
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. 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
Examples 1 2 3 4 5 -- Delete a resource label. openGauss=# DROP RESOURCE LABEL IF EXISTS res_label1; -- Delete a group resource label. openGauss=# DROP RESOURCE LABEL IF EXISTS res_label1, res_label2, res_label3; Helpful Links ALTER RESOURCE LABEL and CREATE RESOURCE LABEL Parent
Examples 1 2 3 4 5 -- Delete a masking policy. openGauss=# DROP MASKING POLICY IF EXISTS maskpol1; -- Delete a group of masking policies. openGauss=# 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 an anonymization policy. openGauss=# DROP MASKING POLICY IF EXISTS maskpol1; -- Delete a group of anonymization policies. openGauss=# DROP MASKING POLICY IF EXISTS maskpol1, maskpol2, maskpol3; Helpful Links 5.1.13.14.14-ALTER MASKING POLICY and 5.13.14.59
Examples 1 2 3 4 5 -- Delete a resource label. openGauss=# DROP RESOURCE LABEL IF EXISTS res_label1; -- Delete a group of resource labels. openGauss=# DROP RESOURCE LABEL IF EXISTS res_label1, res_label2, res_label3; Helpful Links 5.1.13.14.17-ALTER RESOURCE LABEL and 5.1.13.14.64
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
Examples 1 2 3 4 5 -- Delete a resource label. gaussdb=# DROP RESOURCE LABEL IF EXISTS res_label1; -- Delete a group of resource labels. gaussdb=# DROP RESOURCE LABEL IF EXISTS res_label1, res_label2, res_label3; Helpful Links ALTER RESOURCE LABEL and CREATE RESOURCE LABEL Parent
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
Exercise caution when using the DELETE statement to delete a single element. Otherwise, the element sequence may be incorrect.
Exercise caution when using the DELETE statement to delete a single element. Otherwise, the element sequence may be incorrect.
Exercise caution when using the DELETE statement to delete a single element. Otherwise, the element sequence may be incorrect.
public database links. gs_role_seclabel Permission to create, delete, and apply security labels. gs_role_public_synonym_create Permission to create public synonyms. gs_role_public_synonym_drop Permission to delete public synonyms.
Exercise caution when using the DELETE statement to delete a single element. Otherwise, the element sequence may be incorrect.
