RE: Changing Primary Index Question

Posted in 2003

Murray Wood (IList) — Thu, 4 Sep 2003 08:26:31 +1200 — source: Usenet: comp.databases.informix

A column in a primary key cannot be null. 1. Update that column so it is not null. 2. Unload and delete rows with null. MW > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of Bill Hamilton > Sent: Thursday, 4 September 2003 3:12 a.m. > To: informix-list iiug > Subject: Changing Primary Index Question > > > GlacierYesterday I had to add a column to a table that had a 3-column > primary index > and this new column (a nullable column) had to become part of > the primary > key. > The only way I could make it happen was to unload the table > with null in > that spot, > drop the table, add the table, reload the table, add put back > all other > contraints. > > Just for my future reference, is there an easier way (under > IDS 7.31) ? > > sending to informix-list sending to informix-list