Hi Stegt

We will wait for good suggestion for this, but while you are at it start
investing your time in assigning Domains to the fields. I believe, you
could have just altered the domain for eg. named MYDOMAIN from char(100)
to char(255) and all of them would have been updated at one go.

Kind regards
Bhavbhuti

On 19/08/2010 03:12 pm, stegt wrote:
>
> An odd request maybe, but we have a requirement where we need to alter
> a table which has an unknown quantity of char(100) columns to be
> char(255) columns.
>
> All the columns are prefixes 'F' then a number. The customer can add
> additional columns to the table at will, so we need to be able to go
> through a table and update all the char(100) columns to char(255).
>
> I don't suppose there is some SQL black magic that can be used to do this?
>
> The only way I can think of is to somehow extract the metadata from
> the table, then somehow find all the char(100) columns and run SQL for
> each column to update it, but that would mean writing an application
> that the customer would need to run to do the work, rather than just
> supplying a SQL script to do the work.
>
> Any ideas?
>
> Cheers.
>
>

--


Thanking you.

Yours Faithfully,
For Venus Software Operations
----
Bhavbhuti Nathwani
___________________________________________
Softwares for Indian Businesses at: http://venussoftop.tripod.com

venussoftop@...
venussoftop@...
___________________________________________

Please note: We reserve complete rights for policy changes in the future and the same will be applicable immediately as and when made. Attachments may get corrupted before reaching you, in such a situation please let us know and we will resend you the same at the earliest. We do not take any responsibility for data loss of any type and kind. Data safety remains the sole the responsibility of the users of our softwares.
___________________________________________

Internet email confidentiality:

This message may contain information that may be privileged or confidential. If you are not the addressee nor are you responsible for the delivery of the message to the addressee indicated in this email, then you may not copy or deliver this email to anyone and you should notify the sender by reply email and then destroy this message.

Please reply email immediately to this message with REMOVE in the subject, if you or your employer do not consent to email of this kind.

Opinions, conclusions and other information in this message that do not relate to the official business of my firm shall be understood as neither given nor endorsed by my company.