If you plan to truncate table, use the not logged option.
如果您计划截短表，则应该使用“not logged”选项。
TRUNCATE table statement This statement quickly deletes the contents of an entire table without firing triggers.
TRUNCATE 表语句此语句无需激活触发器即可快速删除整个表的内容。
Select the Truncate table action to delete all the existing rows in the Orders table before the data load operation starts.
在数据加载操作开始之前，选择truncate表操作删除orders表中的所有已有行。
Membership of a group that has sufficient authority to issue TRUNCATE TABLE statements and have CREATE TABLE statement privileges.
一组成员，拥有足够的授权来发出TRUNCATE table语句且拥有CREATE table语句权限。
Additionally, there cannot be a foreign key constraint between the table being truncated and other tables, otherwise the truncate table operation fails.
此外，被truncate的表和其他表之间是不能有外键约束的，否则truncate TABLE操作会失败。
Truncate - to delete the records in the existing table.
截去—删除已有表中的记录。
If a NOT LOGGED table encounters an execution error during a data changing statement there is only one choice for DB2: to truncate the table.
如果NOT LOGGED表在执行数据修改语句期间碰到了执行错误，那么对于DB 2来说，就只有一个选择：清空(truncate)该表。
The TRUNCATE command is used to remove all data from a table without generating a rollback.
你可以建一个大一些的回滚段，在执行大的事务使用特别指定。
The TRUNCATE command is used to remove all data from a table without generating a rollback.
你可以建一个大一些的回滚段，在执行大的事务使用特别指定。
应用推荐