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.