- For Constraint and keys.
- Indexing strategy implementation.
- Improve string comparison.
- Maintaining data base field sizing standards
To do this we have to get the max length of current data and the compare it with database definition. We might have to do this for any existing table.
I have written one script which give the comparison of field size defined in table and actual data size. You can use this comparison and write script to make the necessary correction.
You can also use this script with some modification to generate ALTER script if you have defined rule for field size.