Hi,

> A lazy way which I use often. Try at your own risk.
>
> create domain NAME_LONG as varchar(80);
> update RDB$RELATION_FIELDS
> set RDB$FIELD_SOURCE = 'NAME_LONG'
> where RDB$RELATION_NAME = 'STOCK'
> and RDB$FIELD_NAME = 'STOCK_NAME';

Why are you doing this?

Firebird has a statement ALTER TABLE that allows
you to do this without messing around with the system
tables.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com