Sunday, March 11, 2012

Alter several columns using ALTER COLUMN

Hi!

I have a table with 6 columns of type int. I would like to alter this table and set these columns to float. Is it possible to do it using only one statement? I don't want to use the following query six times!

ALTER TABLE T1

ALTER COLUMN C1 FLOAT NOT NULL

Thank you!

What happens when you try to alter multiple columns in one statement?

No comments:

Post a Comment