db2 identity

db2 identity标识定义：

 

create table b_student(

keyid int not nulll  generated always as identity(start with 1,increment by 1),

 

name varchar(10)

)

 

 

insert  into b_student(name)

select name from b_student_bak;