Column marked NOT NULL. No default value. Update may fail.
duanecwilson
Posts: 2
I am getting the following error when deploying with SQL Compare:
The column on table is being marked as NOT NULL. There is no default value so the update may fail.
Most of these columns are part of a compound key so I cannot set them as nullable. I am wondering if I should create a default of an empty string or zero length string, and if it is numeric, what to use.
Or is this error ignorable as just a warning?
The column on table is being marked as NOT NULL. There is no default value so the update may fail.
Most of these columns are part of a compound key so I cannot set them as nullable. I am wondering if I should create a default of an empty string or zero length string, and if it is numeric, what to use.
Or is this error ignorable as just a warning?
Comments
Product Support
Red Gate Software