How do you set a cell to null in datagrip?
If set null is not an option, try synchronizing the table schema. Right click the table and Synchronize (Ctrl-Alt-Y)
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).
In Windows, there are two easy ways:
- Select specific field and then press
Ctrl+Alt+N
- Right click on the specific field and then select
Set NULL
Also, be sure that your field is nullable
otherwise, DataGrip WILL NOT present the Set NULL
option :)