Changing SQL table/field size

[dcjones]

Hi All

Question. After inserting data into a SQL database can I change the size of one of the field inside the table without any damage to the data that is already there.

Regards

Dereck

[pete_bisby]

As long as you're not reducing the size of the field, for example reducing a varchar field from 20 to 10 characters, or you will lose some of your data within that field.

Same with numbers - if you reduce the number of bytes/size of the field, the number will be mis-represented.

If you're increasing the size of the field, then there shouldn't be a problem. If you want to be really sure, create a blank table with the correct definition then copy your data across.

[dcjones]

Hi

Thanks for that, I need to increase a varchar from 64 to 80.

I have just tested as your post and it was ok so I did the increase on the production table (after a back up) with total success.

I just wanted someone to hold my hand.

Many thanks.

Dereck