| Subject | Re: [ib-support] Change varcahr(40) to Varchar(100) |
|---|---|
| Author | Andy Browne |
| Post date | 2003-02-27T11:01:38Z |
Hi Michael
1) Add a temp field varchar(100)
2) copy data from field to temp field (check the copy)
3) drop field Varchar(40)
4) add field Varchar(100)
5) copy from temp field to new field (check copy)
6) drop temp field.
If you have dependancies you will have to sort those out first.
This is long winded but safe!
Andy
"Michael Vilhelmsen " wrote:
1) Add a temp field varchar(100)
2) copy data from field to temp field (check the copy)
3) drop field Varchar(40)
4) add field Varchar(100)
5) copy from temp field to new field (check copy)
6) drop temp field.
If you have dependancies you will have to sort those out first.
This is long winded but safe!
Andy
"Michael Vilhelmsen " wrote:
> Hi
>
> Can I change a field defined as Varchar(40) to Varchar(100) without
> loosing data ?
>
> Michael
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/