If they are primary keys do I need to drop them (constraints) and make the
change and then put the PK back?

Just being careful...

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Ann W. Harrison" <aharrison@...>
To: <ib-support@yahoogroups.com>
Sent: Tuesday, May 01, 2001 8:41 PM
Subject: Re: [ib-support] Changing column type on IB 5.6


> 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.
>
>
> Yahoo! Groups Sponsor
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>