I have problem at time of altering the table to not null.
the syntax I am using is

ALTER TABLE table_name MODIFY column_name NOT NULL

the error is
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'MODIFY'.