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).

identity_1

In General tab select Indentity Column and Auto Increment.

Then select the Auto Increment tab:

identoty_column2

And set the properties as wanted.

Now if you generate the DDL this is what you get:

identity_2

Advertisements