Auto-Increment versus Identity


I am using DG 2017.3. Trying to "Modify Table" in SQL Server 2008 to add auto-increment to an INT PRIMARY KEY column. It won't enable the "Execute" button and tells me right inside the dialog: 

-- SQL Server doesn't support adding auto increment constraints

Wait, what? Sure it does! It's called IDENTITY.

Exited DG, used SQL Server Management Studio to modify the column to add the IDENTITY constraint.

Back in DG, synchronized, going to "Modify Table": "Auto inc" checkbox is checked. So it does support auto-inc after all...?

Things like this undermine the trust in DG as a viable tool to manage all databases. 

Andrew Wozniewicz


Comment actions Permalink

I agree with Andrew. Please address this

Comment actions Permalink

Almost 2 years later and this hasn't been addressed?

Comment actions Permalink

There is an issue in our bug tracker you can vote for and follow


Please sign in to leave a comment.