Re: Column Constraints C=?
From: Bob King <rking_at_dfw.net>
Date: 1995/05/30
Message-ID: <3qesh4$9cq_at_fnord.dfw.net>#1/1
Date: 1995/05/30
Message-ID: <3qesh4$9cq_at_fnord.dfw.net>#1/1
In article <3q60re$sc0_at_news.cais.com>, randyd_at_cais3.cais.com says...
>
>When you query the data-dictionary to find the constraints on
>columns, some come back with a P indicating PRIMARY KEY Column,
>and some come back NULL indicating no constraint, and some
>come back with a C.
>
>What does the C stand for?
This is a "Check" constraint, usually developed for in-line business rule or sanity checks (amount can not be null if quantity > 0), etc. The SQL Language Ref. Manual has full syntax.
-- Bob King - rking_at_dfw.net business ph. - (817) 551-8223Received on Tue May 30 1995 - 00:00:00 CEST