Hello @Kaniz Fatma​, the answer from @Werner Stinckens​ helped. I just created a script that is used to create the table. In the script I specify the identity column and this works.

View solution in original post