When creating defaults, you need to keep in mind the following restrictions:
A default cannot be created on columns that have been defined with
Only one default can be assigned to a given column. This restriction applies to both declarative and bound defaults.
Only one default can exist per column.
The default value must be compatible with the data type of the column.
A default ...