Re: Changing Primary Index Question

You can add the column dynamically, but to make it a part of the index, you will have to recreate the index, since this "NULL" column is part of a multi-column primary key, you will get away with it, but will be out of luck if this is the only column in the index. --- ramesh.vasudevan@verizon.com wrote: > > All: > > Yes .. Primary key field doesn't allow NULL value. > That is the major > difference UNIQUE constraint and PRIMARY KEY > constraint. > btw - UNIQUE index is different from UNIQUE > constraint. > > Thank You > Ramesh Vasudevan > > > > > > > > "John Carlson" > > > <john_carlson@whsm To: > informix-list@iiug.org > > ithusa.com> cc: > > > Sent by: > Subject: Re: Changing Primary Index Question > > owner-informix-lis > > > t@iiug.org > > > > > > > > > 09/03/03 02:24 PM > > > Please respond to > > > "John Carlson" > > > > > > > > > > > > > On Wed, 3 Sep 2003 10:12:18 -0500, "Bill Hamilton" > <bham@finsco.com> > wrote: > > > > >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) ? > > > > As far as I know, the definition of a PK doesn't > allow a nullable > column . . . . am I wrong? > > > > > > > sending to informix-list __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com sending to informix-list