Changing keyfield

[sven2]

Hello,

I have to change the length of a keyfield from 4 to 8 digit. This keyfiels connect 15 tables and I want to know if I can change this value without removing the links?

Is this possible? And what is the most easy way?

Thanks in advance,
Sven.

 

[SQL_Hell]

What data type is it?