I have a table with a field type Decimal set at (5,2). I want to change it to (7,2). Would you advise it would be OK to just change the field like so -
ALTER COLUMN my_field DECIMAL(7,2);
or would it be best to create a new column, update the new column with the data and then delete the old column?
Many thanks.
I don’t know. But you have to backup your DB before doing the changes anyway, so why not make that backup and give it a try 
If it doesn’t work, just put back the backup and try the other way.
Did you try? It sure looks like a lot less work, doesn’t it
Not yet! I have used both these methods before but on my own small databases. I’ve never tried it with decimal type though and this database is quite large. I imagine it should be ok but before creating headaches for myself later on I was hoping for some advice