Hi

I had a very similar problem a while back and decided after helpful coments from this list that the best way for me was to actullay drop all the referencing objects, change the type and create the droped items again.

It might also be possible to do this just by changing the domain in one of the system tables. I don't know much about this but this is what my third party administration tool atempts to do when I ask it to change a type of a column.

Tim

> -----Original Message-----
> From: Rick Debay [mailto:rdebay@...]
> Sent: den 29 september 2005 23:54
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Altering column types
>
> I'm trying to change a column type from char(1) to a domain
> that is char(1), and a column that is Numeric(11,0) to
> Varchar(19). In both cases, all data in the column will fit
> in the destination type.
> In both cases, I get the error that another something
> (constraint, index, stored procedure, trigger) has a
> dependancy on the column so its type can't be changed.
> Is there anything that can be done besides changing every
> item to not reference the column, change it, and then add all
> the references back?
>
> Secondly the domain in the char(1) change has no
> character-set type, nor does the column. Yet when I try to
> make the change, it complains that I can't change the character set.
>
> Thanks, Rick DeBay
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~--> Fair play? Video games influencing
> politics. Click and talk back!
> http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/67folB/TM
> --------------------------------------------------------------
> ------~->
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources
> item on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>