Subject Changing domain from Char to Integer
Author Ed Dressel
I inadvertantly misdefined a domain as char which was suppose to be
interger. Will the following fix the problem (i.e. am I allowed to
redefine a field with a Char domain an integer domain)?

Thanks
Ed Dressel

Create domain DM_TEMP INteger;

update RDB$RELATION_FIELDS set
RDB$FIELD_SOURCE = 'DM_TEMP'
where (RDB$FIELD_SOURCE = 'DM_INTEGER')

drop domain DM_INTEGER;
Create domain DM_INTEGER INTEGER default 0;

update RDB$RELATION_FIELDS set
RDB$FIELD_SOURCE = 'DM_INTEGER'
where (RDB$FIELD_SOURCE = 'DM_TEMP')

Drop domain DM_TEMP;