检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
The TRUNCATE statement can delete all data in a table but does not delete the table structure. The deletion speed of the DELETE statement is the slowest. You can delete data from a table based on conditions, excluding the table structure. Parent topic: FAQ
The TRUNCATE statement can delete all data in a table but does not delete the table structure. The deletion speed of the DELETE statement is the slowest. You can delete data from a table based on conditions, excluding the table structure. Parent topic: FAQs
How Can I Delete the GaussDB Backup Policy? Sorry, you cannot delete the GaussDB backup policy. When you create a GaussDB instance, the instance-level automated backup policy is enabled by default. You can modify the backup cycle and retention period on the console.
How Do I Enable the Audit of INSERT, UPDATE, and DELETE Operations in GaussDB? You can enable the audit of INSERT, UPDATE, and DELETE operations on the GaussDB console. Specifically, perform the following operations: Log in to the management console.
DELETE [Rule] The DELETE statement must contain the WHERE clause to avoid full table scan. [Rule] Do not use ORDER BY or GROUP BY in the DELETE statement to avoid unnecessary sorting. [Rule] Use TRUNCATE instead of DELETE to clear a table.
Precautions The owner of a table, users granted the DELETE permission on the table, or users granted the DELETE ANY TABLE permission can delete data from the table.
Precautions The owner of a table, users granted the DELETE permission on the table or the DELETE ANY TABLE permission can delete data from the table. When separation of duties is disabled, system administrators have this permission by default.
Precautions The owner of a table, users granted with the DELETE permission on the table, or users granted with the DELETE ANY TABLE permission can delete data from the table.
Precautions The owner of a table, users granted with the DELETE permission on the table, or users granted with the DELETE ANY TABLE permission can delete data from the table.
Precautions The owner of a table, users granted with the DELETE permission on the table, or users granted with the DELETE ANY TABLE permission can delete data from the table.
Precautions The owner of a table, users granted with the DELETE permission on the table, or users granted with the DELETE ANY TABLE permission can delete data from the table.
[Rule] The DELETE statement must contain the WHERE clause to avoid full table scan. [Rule] Do not use ORDER BY or GROUP BY in the DELETE statement to avoid unnecessary sorting. [Rule] Use TRUNCATE instead of DELETE to clear a table.
[Rule] The DELETE statement must contain the WHERE clause to avoid full table scan. [Rule] Do not use ORDER BY or GROUP BY in the DELETE statement to avoid unnecessary sorting. [Rule] Use TRUNCATE instead of DELETE to clear a table.
[Rule] The DELETE statement must contain the WHERE clause to avoid full table scan. [Rule] Do not use ORDER BY or GROUP BY in the DELETE statement to avoid unnecessary sorting. [Rule] Use TRUNCATE instead of DELETE to clear a table.
Deleting a Level-2 Partition from a Level-2 Partitioned Table You can run ALTER TABLE DROP SUBPARTITION to delete a level-2 range or list partition from a level-2 partitioned table.
Deleting a Level-2 Partition from a Level-2 Partitioned Table You can run ALTER TABLE DROP SUBPARTITION to delete a level-2 range or list partition from a level-2 partitioned table.
For example, delete the partition date_202005 from the range partitioned table range_sales by specifying the partition name and update the global index.
You can delete several rows that match the specified condition or delete all the rows from a table.
You can delete several rows that match the specified condition or delete all the rows from a table.
Precautions CASCADE is used to delete the objects (excluding databases) that depend on the user. It cannot delete locked objects unless the objects are unlocked or the processes locking the objects are killed.
