数据库 结构语句 里 先删除
GENERATED ALWAYS AS IDENTITY (
START WITH +1
INCREMENT BY +1
MINVALUE +1
MAXVALUE +9223372036854775807
NO CYCLE
CACHE 20
NO ORDER )
自增。
删除外键
然后导入数据
用 icv或者什么方式都可以。
最后再 加上自增和外键
关闭外键
SET INTEGRITY FOR t_areas FOREIGN KEY IMMEDIATE unchecked
插入自增
Alter table <table name> alter column "FD_ROWID" set generated always as identity (start with 1,increment by 1)
ALTER TABLE db2admin.T_MAP_ICON ALTER COLUMN FD_ROWID DROP IDENTITY;
T_APPENDANT
T_AREAS
T_BASEINFO
T_BASEINFO_LOG
T_BASEINFO_PARAM
T_BASEINFO_USER
T_BINDINGDEVICE
T_CHECKEQUMENT
T_CHECKINFO
T_CHECKLOG
T_DATALOG
T_DEPTINFO
T_EQUMENTPARAM
T_FIXRECORD
T_GROUPINFO
T_INFORMATION
T_JURISDICTION
T_MANAGER
T_MAP_ICON
T_MESSAGE
T_MESSAGE_GROUP
T_MESSAGE_SEND_LOG
T_MESSAGE_USER_deprecated
T_REALDATA
T_RECORD
T_RESINFO
T_ROLEINFO
T_ROLE_RES
T_SENDRULE
T_SENSOR
T_SYSPARA
T_TEAMGROUP
T_TEAMGROUP_RES
T_TEAMGROUP_USER
T_USERINFO
T_USER_DEPT
T_USER_RECORD
T_USER_RES
T_USER_ROLE
T_WEIGH_RECORD
T_WEIGH_RESUME
评论区