Sybase Error – Cannot enforce the NOT NULL constraint. Column %2 has NULL data. %1

In this blog post, you’ll learn more about the Sybase Error Cannot enforce the NOT NULL constraint. Column %2 has NULL data. %1 and the reason for receiving this error

Sybase SQL Error Message

Cannot enforce the NOT NULL constraint. Column %2 has NULL data. %1

Reason for this Error

The user tried ALTER MODIFY column NOT NULL on a column that used to allow nulls and has null data. The user has to first delete the null rows before altering the column to enforce the NOT NULL constraint.