How do you set a cell to null in datagrip?

Question

Is there a quick way without diving into sql to set a particular attribute back to null? entering in "" doesn't work.

Accepted Answer

You can either:

- Select the field, right-click, and select "Set NULL"

- Select the field, press CTRL+ALT+N (on Windows).

Note that boolean fields will show up as a box filled with a dash (-) when null.

If the "Set NULL" option is not appearing, you might need to refresh the schema which you can do by clicking the synchronize button:

or by pressing Ctrl+Alt+Y (on Windows).

Solution