Hi Christian,

Here is one way to do it:

CREATE DOMAIN NEWDOMAINNAME AS
VARCHAR(750);

update RDB$RELATION_FIELDS set
RDB$FIELD_SOURCE = 'NEWDOMAINNAME'
where (RDB$FIELD_NAME = ',your field name') and
(RDB$RELATION_NAME = 'your table name');

Regards,
Mike Simmons

At 12:32 PM 6/1/2005, you wrote:

>Hi,
>
>I have to enlarge a VARCHAR column from 20 to 50 chars.
>As this column is referenced by many triggers and SPs, I cannot
>just delete and recreate it by using a helper field.
>
>I could perhaps do it like that:
>
>update RDB$FIELDS set
>RDB$FIELD_LENGTH = 50,
>RDB$CHARACTER_LENGTH = 50
>where RDB$FIELD_NAME = 'RDB$353'
>
>Many direct modifications of system tables are dangerous, so I would
>rather avoid this. Is there another way? Or can somebody confirm that
>the above query is not dangerous?
>
>Thanks in advance,
>
>
>Christian
>
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>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
>
>
>
>

[Non-text portions of this message have been removed]