Re: Modifying primary key field
From: Randy Dewoolfson <randyd_at_cais3.cais.com>
Date: 1996/07/23
Message-ID: <4t14pt$dfc_at_news2.cais.com>#1/1
Date: 1996/07/23
Message-ID: <4t14pt$dfc_at_news2.cais.com>#1/1
drop all the constraints first,
modify the field,
re-apply the constraints.
Randy :)
B. Yim (yimfam_at_pc.jaring.my) wrote:
: 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.
-- ..uu. ---------------------- .?$" '?i . I Randy DeWoolfson I .T^M ._at_" d9 . f ,.un. b, i I--------------------I " Z :#" M `8 U < .dP"``"# `M _at_" I randyd_at_cais.com I &H?` Xl _R $5. $ ?* _at_ 'P,#" I--------------------I ,d#^*L :RP'~$b f`$L:M Xf .f' dH` I ,\//. I & 'M ,P `E M "$ Mux~ n!` I |o o| I dk `h" ' j " y" *~ I====oOO==(_)==Ooo===IReceived on Tue Jul 23 1996 - 00:00:00 CEST