DF087: NULL or NOT NULL constraint is not specified.

The topic describes the DF087 T-SQL code analysis rule.

Category

BEST PRACTICE

Message

NULL or NOT NULL constraint is not specified.

Description

It is recommended to explicitly specify the nullability of a table column in the CREATE/DECLARE TABLE and ALTER TABLE ADD COLUMN statements.

Noncompliant code example


Compliant solution