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.

score 41 · Accepted Answer · edited Feb 05 '19 at 11:15

41

You can either:

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).

edited Feb 05 '19 at 11:15

Pablo Fernandez

answered Oct 31 '16 at 02:54

Gus King

1

Sorry but I think thats poor design.. it should be smart enough ...as it does with most things...and recognize me typing "N-U-L-L" and know what I mean. Right clicking wasn't my first thought. – greaterKing Jul 12 '17 at 03:33
9

Couldn't find the "Set NULL" option on 2017.2 version. – Ganbayar Gansukh Oct 05 '17 at 14:06
6

Sometimes if you don't have "SET NULL" in the right-click, you need to refresh your schema. Right click on the table and Synchronize (Ctrl Alt Y) – Dustin Graham May 03 '18 at 22:57
Set NULL is only displayed for nullable fields – Ricardo Martins Jun 10 '20 at 00:26
On macOS, you can also right click the entry and select "set NULL" or use this shortcut – d0zingcat Sep 18 '21 at 06:03

score 9 · Answer 2 · answered May 03 '18 at 22:59

9

If set null is not an option, try synchronizing the table schema. Right click the table and Synchronize (Ctrl-Alt-Y)

answered May 03 '18 at 22:59

Dustin Graham

score 4 · Answer 3 · answered Apr 01 '19 at 10:41

4

In Windows, there are two easy ways:

answered Apr 01 '19 at 10:41

Sina Lotfi

score 3 · Answer 4 · answered Aug 05 '22 at 10:58

3

Also, be sure that your field is nullable otherwise, DataGrip WILL NOT present the Set NULL option :)

answered Aug 05 '22 at 10:58

ChromeKK

4 Answers4