I'm trying to use DataGrip, I have come across a major blocker.
I have a Sql Azure table with a primary key "Id" field that is set as an Identity(1,1)
. In DataGrip, it shows the column as Id INT (auto increment)
.
I clicked on the table and opened the table editor. I then added a new record but left the Id
column blank. However, when I go to commit my changes, it says that it cannot insert explicit values for identity column.
Is it not possible to add new records in DataGrip with an identity column?
It looks like that issue was fixed a couple years ago.