Alter column in Single query

Question

Hi all I am a logical issue. I want to alter the data type of the some columns but to alter the data type of each column I will have to write the query number of times. for example alter table ratesys_gc_cdr alter column moderator_id varchar(10) -- -- -- alter table ratesys_gc_cdr alter column n varchar(10) So the my question is can we make it in a single alter script? I am using sqlserver 2005.

Manikavelu Velayutham · Answer

you cant make it in single alter script instead you can create a db script and then run it in single execution. like alter table.....go alter table.....go finally you can execute the line at once.

Manikavelu Velayutham · Answer

If your problem solved you can mark my post as answered

anil indorkar · Answer

Hi Manikavelu Thanks for the reply. I want to make sure this is not possible in single alter script. I have done in what way you have described.