To Copy into identity columns

Database
N/A

To Copy into identity columns

Hi All,
Is there a way to copy integer values from one table to another table.The destination column is an identity column .I am able to copy but not the same values of source and destination.
I have to do this only once for my history records.
please throw a light on this......

1 REPLY

Re: To Copy into identity columns

Hi,
Define your identity column as 'GENERATED BY DEFAULT AS IDENTITY'.

Rgds,
Aravind Hegde