Specifies whether the column can accept NULL values. Columns that do not allow NULL values can be added only if they have a default specified. If the new column allows NULL values and no default is ...

Specifies the properties of a PRIMARY KEY, FOREIGN KEY, UNIQUE, or CHECK constraint that is part of a new column definition added to a table by using ALTER TABLE. Is the name of the constraint.