How can we help you today? How can we help you today?

Column marked NOT NULL. No default value. Update may fail.

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?
duanecwilson
0

Comments

1 comment

Sort by
  • Manfred.Castro
    It's a warning, but if any null data exists in the table already the update will fail.
    Manfred.Castro
    0

Add comment

Please sign in to leave a comment.