> 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