Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: OFFTOPIC Re: Naming DEFAULT constraints

Re: OFFTOPIC Re: Naming DEFAULT constraints

From: Anurag Varma <avoracle_at_gmail.com>
Date: 29 Jan 2007 06:55:20 -0800
Message-ID: <1170082520.647685.67250@h3g2000cwc.googlegroups.com>

On Jan 29, 5:56 am, "Paul" <paulwragg2..._at_hotmail.com> wrote:
> OK, it would appear that the constraints I thought I was looking at
> were the default constraints. Sadly this is not the case and the
> constraints I see above are actually check constraints to enforce the
> nullability of the columns.
>
> Sorry for any time anybody has wasted on this!!

Yes, the constraint you saw was for the not null constraint. All constraints can be named, including not null. Let us know if you need any help in sytax for naming a not null constraint...

Cheers,
Anurag Received on Mon Jan 29 2007 - 08:55:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US