To Copy into identity columns

Database
Enthusiast

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
Enthusiast

Re: To Copy into identity columns

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

Rgds,
Aravind Hegde