At 05:08 PM 5/1/2001 -0700, Jason Wharton wrote:

>What was the metadata table updates that could be done to change an integer
>column to a string column. I know it has to do with changing the RDB$FIELDS
>table but I don't remember where on the net the articles for it are at. I'm
>in a bit of a hurry as this task just fell upon me and if need it done
>quickly. It's a rather huge database too.

deactivate any indexes used for the column. Find the rdb$fields record
that is the domain for the column (rdb$relation_fields -> rdb$field_source)
Change the type to 14 (better check that ... I think char is 14 and varchar
35, but my memory is fallible). Specify a length and a character length,
commit, then recreate the indexes.


Regards,

Ann
www.ibphoenix.com
We have answers.