Loading

Alter column in Single query

anil indorkar

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.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manikavelu Velayutham16y ago
Accepted 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 Velayutham16y ago
If your problem solved, you can mark my post as answered
anil indorkar16y ago
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.