1： 删除表
DROP TABLE "SCOTT"."GRP_200803";
2:修改表记录内容：
db2 => update swimpool set slope='No' where ID='1'
3: 获得当前日期
db2 => Values CURRENT DATE
1
----------
2008-03-13
4: 修改表名
db2 => RENAME TABLE "SCOTT"."GRP_CRM_COLORRING_200712N" TO "SCOTT.GRP_CRM_COLORRING_200712"
阅读(1103) | 评论(0) | 转发(0) |
