datagrip

How do I insert a row with an identity column with DataGrip?


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?


Solution

  • It looks like that issue was fixed a couple years ago.

    enter image description here