Alter Column(s)?

[paulosinuk]

Hi

Can you use the alter column statement to alter more that one column at a time, I don't seem to be able to find the right syntax to do this?

Thanks

Paulos

 

[manjarikosaraju]

Seperate each new column by a comma..

ALTER TABLE <TABLENAME>
ADD <columnname> <datatype>,
<columnname> <datatype>,
<columnname> <datatype>

 

[manjarikosaraju]

OOPS!!! I read it as add columns instead of alter columns.
Just ignore the previous post.

-Manjari

 

[paulosinuk]

So is there a syntax for being able to alter multiple columns in the same statement?

 

[JamesLean]

No, you have to use multiple ALTER TABLE statements.

ALTER TABLE t
ALTER COLUMN c1 ...

ALTER TABLE t
ALTER COLUMN c2 ...

--James