Re: Constraint types

It means a NOT NULL constraint -- as in: CREATE TABLE SomeTable ( SomeColumn CHAR(20) NOT NULL ); It is new in 7.1x, where I think x is 0.UD1 or later (but not 0.UC1), but I stand to be corrected on the detailed version number. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> -- email address mangled somewhere along the line... >From: Mark Yingling <mying@tonto.informix.com> >Date: Tue, 23 Jan 96 09:05:25 PDT >X-Informix-List-Id: <news.20529> > >I have been attempting to place primary and foreign key constraints on an >existing database, and have seen something in the SYSCONSTRAINTS table that I >can't account for. The manual being the most user friendly of references (sic) >does not mention a CONSTRTYPE of "N", yet I see these types entered in this >table. Can someone explain what this type is and how it gets defined.