I thought they were essentially the same thing... :-)

Saves a few characters worth of typing I suppose!

N.

>> Hi all,
>>
>> I have a need to change an Integer field to a Numeric(18,0), and it's a
>> primary
>> key, that's referenced by about 24 tables.
>>
>> Do I really have to:
>> Drop each foreign key constraint
>> Drop the primary key constraint
>> Copy the field to a temporary field
>> Drop the original field
>> Create a new one of the new type, with the original field name.
>> Re-instate the primary key contraint
>> and re-instate all the foreign key constraints?
>>
>> Hopefully there's a quicker solution... :-)
>>
>> Nige.
>
> just as an aside, why are you going to numeric(18,0) and not bigint?
> Alan
>
>