DB2 数据库清表语句

truncate table DWDM2.tablename  IMMEDIATE;

alter table DWDM1.tablename  activate not logged initially with empty table;


but which one is best ? the truncate should be better

posted @ 2016-05-04 20:16  yuerspring  阅读(691)  评论(0编辑  收藏  举报