I want to define an identity column and set the Auto Increment properties. How can I do that?
This definition can be made in the relational model. Select the primary key column and go to the Column Properties (the XYZ and a pen icon).
In General tab select Indentity Column and Auto Increment.
Then select the Auto Increment tab:
And set the properties as wanted.
Now if you generate the DDL this is what you get: