CODEWITHSUNDEEP
datagrip
modernNeo
modernNeo

Reputation: 145

How to show un-committed changes in a database table in DataGrip?

How can I run a statement in the SQL query console in manual mode on DataGrip and see their effect on the table locally in order to make sure it has the intended effect before committing it to the database?

Upvotes: 2

Views: 1451

Answers (3)

Eduardo Toural
Eduardo Toural

Reputation: 79

See here the one highlighted in red "Preview Pending Changes", it will open the DML Preview modal. enter image description here

Upvotes: 1

modernNeo
modernNeo

Reputation: 145

There is a context action "Preview update". (right click on statement > show context actions)

Upvotes: 0

Vasilii Chernov
Vasilii Chernov

Reputation: 1464

From DataGrip 2020.2 you can review the query that represents your changes in the data editor.

DML button is active if there are pending changes: DML Preview

Upvotes: 1

Related Questions