Specificallly, I want to reduce the field size for a number of fields. The values that are currently in the table will not exceed the field size I want to change it to, but I am wondering if it is possible that I will lose data if I reduce the size. I would rather not change the size if data will be lost.
I want to change the table structure after data has already been entered
- Thread starter Romulus
- Start date
Rakier
Registered User.
- Local time
- Today, 03:36
- Joined
- Mar 21, 2002
- Messages
- 75
I don't think that you will lose data as long as the current data does not violate any of the new rules that you add to the table structure. Specifically, if you change it from 50 characters to 10 and have no data longer than 10 characters in the field...you should be okay.
Of course...backup before you do anything!
Of course...backup before you do anything!
