Adding an identity Column

[nabeelaslam1994]

Hello Team,

Is there a way to add an identity column in qlik replicate? A target table will have new column and have 1,2,3,4 Row number generated by Qlik?

[Sreekanth_333]

Hi @john_wang , Do we have similar internal parameter in target endpoint Microsoft SQL Server top create table with auto increment column ?

[john_wang]

Hello @Sreekanth_333 ,

IN general we can control the target side table creation behavior by internal parameter however there are some exceptions, unfortunately SQL Server is one of the exception. 

Anyway, please allow us some time, we'd like to confirm for you if any chance. Will get back to you later.

Regards,

John.

[DesmondWOO]

Hi @nabeelaslam1994 , @Sreekanth_333 ,

John and I have tested. Changing syntax does not work on the SQL Server.

Regards,
Desmond