一、导出该表的数据;二、删除原表,重新建,新建表脚本修改row_id字段属性增加‘GENERATED BY DEFAULT as IDENTITY’;三、导入数据。DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08027" with level identifier "03080106".Informationa...
显示全部一、导出该表的数据;
二、删除原表,重新建,新建表脚本修改row_id字段属性增加‘GENERATED BY DEFAULT as IDENTITY’;
三、导入数据。
DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08027"
with level identifier "03080106".
Informational tokens are "DB2 v8.1.2.128", "s061108", "MI00176", and FixPak
"14".
Product is installed at "/opt/IBM/db2/V8.1".
收起