Red Gate forums :: View topic - Column marked NOT NULL. No default value. Update may fail.
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

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

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
duanecwilson



Joined: 26 Sep 2012
Posts: 1
Location: Greenville, SC

PostPosted: Wed Sep 26, 2012 3:47 pm    Post subject: Column marked NOT NULL. No default value. Update may fail. Reply with quote

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?
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 205

PostPosted: Fri Sep 28, 2012 5:08 pm    Post subject: Reply with quote

It's a warning, but if any null data exists in the table already the update will fail.
_________________
Manfred Castro
Product Support
Red Gate Software
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group