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:
— ERROR: Datatype UNKNOWN is not allowed 😉
Oh well I guess there’s a bit more to setting up an Identity column
Thank for your comment. I updated those screenshots. It is really that simple. This post was written in a hurry to explain somebody where to find those properties. Thanks!
Pingback: Weekly Link Roundup - Feb 3, 2017 - Database Star