How do I insert a record into a Sql Server table that has an identity column?

In trying to use Datagrip instead of Sql Server Management Studio, I have come across a major blocker.

I have a Sql Azure table with a primary key "Id" field that is sent 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?

0

Hello Matthew,

I've created the https://youtrack.jetbrains.com/issue/DBE-2922 issue for it. Please follow for updates.

0

请先登录再写评论。