Sybase Error – Cannot add column ‘%3’ with ‘not null’ constraint on table %2 with data. %1

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.