RE: In Diyotta SQL SERVER dataobject is there a provision to select the Identity column.
If a column in SQL server table is defined as identity, then it is indicated in the data object, once the data object is imported into the Project.
You can also manually indicate an attribute to be an identity column by enabling the checkbox in the data object.
Currently, the seed and increment for the identity column default to 1 in the create table statement for the data object. So if the SQL server table is created with identity enabled then seed and increment will be set to 1.