Code Inspection: Adding not null column without default value

Reports attempts to create NOT NULL columns without DEFAULT values.

Example (Microsoft SQL Server):

CREATE TABLE foo (a INT, b  INT)

ALTER TABLE foo ADD c INT NOT NULL;

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.

ALTER TABLE foo ADD c INT NOT NULL DEFAULT 42;

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

Suppress an inspection in the editor

Place the caret at the highlighted line and press Alt+Enter or click .
Click the arrow next to the inspection you want to suppress and select the necessary suppress action.

Last modified: 11 February 2024