SQL table field size 1

[dmorse]

I need to increase the size of a field in one of my Tables. If I make this change, will I risk corrupting the data in the table.

 

[SQLSister]

Increasing the size is generally not a problem. However, depending on how you are inserting data, you may also need to change you insert/update procedures to give them the same size or you still won't be inserting data in the greater length.

As with any database structure change, you should make sure you do a backup before making the change especially to a production database.

Questions about posting. See faq183-874

 

[dmorse]

SQLSister,

Thanks for the help. I had a second, very small database with 1 table that I exported the table to for a second backup, removed the ability for anyone to access the table, and the update went beautifully.