CODEWITHSUNDEEP
sql-serverdatabasealter-table
Cliff Crerar
Cliff Crerar

Reputation: 443

Alter column script not working

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.

Upvotes: 2

Views: 5786

Answers (1)

Dmytro I.
Dmytro I.

Reputation: 324

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

Upvotes: 1

Related Questions