Because nobody answered to Subject 'Change Datatype', i will ask in a
different way.

I use following statements for converting a primary key with smallint
datatype to an integer datatype:

CREATE DOMAIN D_INTEGER AS INTEGER;

/*lookup - table*/
update RDB$RELATION_FIELDS set
RDB$FIELD_SOURCE = 'D_INTEGER'
where (RDB$FIELD_NAME = 'ID') and
(RDB$RELATION_NAME = 'SALUTATION')
;

/*master - table */
update RDB$RELATION_FIELDS set
RDB$FIELD_SOURCE = 'D_INTEGER'
where (RDB$FIELD_NAME = 'SALUTATION') and
(RDB$RELATION_NAME = 'CUSTOMER')
;

Are there any problems with this conversions?

For the final conversion are update statements necessary ('UPDATE
salutaion SET id = id') or is a backup - restore sufficient?


Kind regards,

Ch.