In this blog post, you’ll learn more about the Sybase Error Cannot add column ‘%3’ with ‘not null’ constraint on table %2 with data. %1 and the reason for receiving this error
Sybase SQL Error Message
Cannot add column ‘%3’ with ‘not null’ constraint on table %2 with data. %1
Reason for this Error
The user tried to ALTER ADD a NOT NULL column to a table that has data. The newly added column would violate the NOT NULL constraint as it would have null data.