Re: Null field part of primary key

Yudong Sun <ysun@econnect.ca> wrote: :Apparently, it's illegal for a field which is part of the primary :key to have a null value. Is this INFORMIX-specific or a widely :accepted implementation due to some logical or technical problems? :Than you. It's a basic part of the SQL standard. To allow null values in a primary key would have several devastating effects although it might seem "nice" for some purposes. You have a bad database design if null values are required in primary key columns. Nils.Myklebust@ccmail.telemax.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company