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

Beginner Asked on May 27, 2020 in Diyotta Studio.
Add Comment
1 Answer(s)

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.

RE: In Diyotta SQL SERVER dataobject is there a provision to select the Identity column.

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.

RE: In Diyotta SQL SERVER dataobject is there a provision to select the Identity column.

 

Expert Answered on May 27, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.