Default Values and Collations

If you specify a NOT NULL constraint for a column, one of the following must happen:

The default can be specified as a literal, a user value function, a datetime value function, or NULL (if you don't specify a default, the column is assumed to be nullable).