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: