All Forums Database
leaca 1 post Joined 02/16
22 Feb 2016
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:
dnoeth 4628 posts Joined 11/04
24 Feb 2016

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.

Dieter

You must sign in to leave a comment.