[AHU Key] column is present in 38 tables.Its size is 15
There are 56 FK relationships among the above tables.
Purpose: To change key's size to, say 50.
Why is this question here? Please see the attached image.
Finally the question itself:
Can anybody suggest a safe
method of changing lengths of [AHU Key] in all 38 tables?
If anybody doesn't acknowledge what it is about, then please do not bother. Also please do not reply with trivialities like "delete all foreign keys and then restore them" (because "safe" above is a key word).
P.S. Live situation is about 4 times more complex (plus [CHi Key], [Hyd Key], [Met Key]).
Experts Exchange has already helped
me to do it in my multiple MS Access databases.