can db2 luw v9.5 express-c support alter column from integer to identity?
i have a table which primary key is an integer column with generated by default property.i now want to move data from the table to a new one, but the problem is if i just perform insert and select data from the old one, the primary key of the new table would different from the old table.
can i create the new table with primary key is integer at first, and then change its type from integer to identity column after inserting data from the old table?
my db2 version is LUW v9.5 express-c, thanks in advance!
页:
[1]