| Subject | Re: How to modify the column size |
|---|---|
| Author | Adam |
| Post date | 2006-04-12T11:36:07Z |
--- In firebird-support@yahoogroups.com, <suresh.dodda@...> wrote:
appropriate scripts for you.
The second easiest way is:
1) Temporarily remove dependencies on the column to change
2) Create a new field with the correct datatype size.
3) Copy the data into the new field (casting as necessary)
4) Drop the old field
5) Rename the new field
6) Reinstate the dependencies you removed in (1)
Adam
>The easiest way to do it is to use a tool that generates the
> I am new to FireBird. I tried on the web but mo information.
> How do I change(increase/decrease ) the column size in FireBird.
>
appropriate scripts for you.
The second easiest way is:
1) Temporarily remove dependencies on the column to change
2) Create a new field with the correct datatype size.
3) Copy the data into the new field (casting as necessary)
4) Drop the old field
5) Rename the new field
6) Reinstate the dependencies you removed in (1)
Adam