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