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