too late to reply- this is what i tried and it worked -
Code:
alter table table_name alter column column_name set not null