Search code examples
datagrip

How do you set a cell to null in datagrip?

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

Solution

  • You can either:

    1. Select the field, right-click, and select "Set NULL"
    2. 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:

    enter image description here

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