DataGrip
 
Get DataGrip
You are viewing the documentation for an earlier version of DataGrip.

Code Inspection: Adding not null column without default value

Last modified: 13 May 2022

Reports attempts to create NOT NULL columns without DEFAULT values.

Example (Microsoft SQL Server):

By default, a column holds NULL values. In the example, we use the NOT NULL constraint that enforces a column not to accept NULL values. If we prohibit to use NULL values, we must set the DEFAULT value that SQL can use when we create a new record.

You can quickly add the DEFAULT value by using the Add DEFAULT value quick-fix.