检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
RESTRICT: refuses to delete the table if any objects depend on it. This is the default action. PURGE Specifies that even if the recycle bin function is enabled, the table is physically dropped instead of being moved to the recycle bin when you use DROP TABLE to delete tables.
If command is set to DELETE, only tuple data that meets the condition (the return value of using_expression is TRUE) can be deleted. The operations that are affected include DELETE and DELETE ... RETURNING.
DELETE: The DELETE process of enhanced TOAST does not depend on the TOAST data index. Instead, data is traversed and deleted based on the linking information between data. UPDATE: The UPDATE process of enhanced TOAST is the same as that of TOAST. Parent topic: Enhanced TOAST
DELETE: The DELETE process of enhanced TOAST does not depend on the TOAST data index. Instead, data is traversed and deleted based on the linking information between data. UPDATE: The UPDATE process of enhanced TOAST is the same as that of TOAST. Parent topic: Enhanced TOAST
In the view, the RETURNING clause can be added to the INSERT, UPDATE, and DELETE rules to return columns by view. If a rule is triggered by the INSERT RETURNING, UPDATE RETURNING, or DELETE RETURNING command, these clauses are used to calculate the output result.
a resource label. gaussdb=# DROP RESOURCE LABEL func_label, view_label, schema_label, column_label, table_label; -- Delete the func_for_label function. gaussdb=# DROP FUNCTION func_for_label; -- Delete the view_for_label view. gaussdb=# DROP VIEW view_for_label; -- Delete the
In the view, the RETURNING clause can be added to the INSERT, UPDATE, and DELETE rules to return columns by view. If a rule is triggered by the INSERT RETURNING, UPDATE RETURNING, or DELETE RETURNING command, these clauses are used to calculate the output result.
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.
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.
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
To delete a cluster node, you only need to connect to one CN. If a cluster node is created on only one CN, you need to define the current CN name and delete the cluster node on the current CN.
-- 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
If you do not need the backups anymore, delete them manually. If your instance is frozen, its backups are not billed. Automated backups and their related files are automatically deleted. Parent Topic: Backup and Restoration
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.
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
RESTRICT: refuses to delete the table if any objects depend on it. This is the default.
When separation of duties is disabled, the system administrator has the permission to delete the specified table by default.
