In Diyotta SQL SERVER dataobject is there a provision to select the Identity column.
In MSSQL table i have a requirement to specify the column as Identity column. How do we achieve that in MSSQL dataobject
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.