teradata insert to identity column?

Database
N/A

teradata insert to identity column?

Hai, i want to insert value to identity column,

is there syntax like

SET IDENTITY_INSERT ON | OFF ------- SQL SERVER
in teradata ??

This is for migrating data from table1 to table2, both of tables have identity column ?
Help

Thanks.
Tags (1)
1 REPLY
Junior Contributor

Re: teradata insert to identity column?

There's no syntax like that in Teradata, you can only create the Identity using GENERATED AS DEFAULT.

But then you must adjust the MINVALUE to the maximum actual value plus one.