You have to use the alter table statement.

alter table Company alter column CompanyName varchar(40)
COLLATE SQL_Latin1_General_CP1_CI_AI null