Alter column script not working

Question

I ran the following script to change the the field 'Asdes' from nvarchar(255) to varchar(150) in the table 'Verdata'.

Alter table Verdata
Alter column asdes varchar(150)

The script runs without errors yet the field remains unmodified when I enter the table design mode.

Answer 1

Try adding semicolon at the end of the query or put 'GO' after it