Is there a way to alter more then one column at the same time.

I need to run something like this:

alter table tblRptConfig
alter column1 varchar(100), column2 varchar(50)...
go


TIA,

yes there is,

Instead of using alter column use the modify command. It goes something like
this:

alter table tblrptConfig
modify(column1 varchar(100), column2 varchar(50));

I hope I was able to answer your question.

good day.
>
----- Original Message -----
From: "Ougnou, Abdel" <aougn99@h...>
To: "Application Development" <application_development@p...>
Sent: Thursday, February 13, 2003 11:32 AM
Subject: [application_development] Alter Column


>
> Is there a way to alter more then one column at the same time.
>
> I need to run something like this:
>
> alter table tblRptConfig
> alter column1 varchar(100), column2 varchar(50)...
> go
>
>
> TIA,
>
>
>