Modifying primary key field

Hello,

I have a table with the primary key defined on a char(5) field. This primary key is referenced by a lot of foreign keys in other tables. I need to expand this field to char(6) but could not do it with the alter table command - problem with integrity constraints violations. Can anyone suggest a way to get around this problem.

Thanks a lot. Received on Tue Jul 23 1996 - 00:00:00 CEST