Re: Naming DEFAULT constraints

From: Anurag Varma <avoracle_at_gmail.com>
Date: 26 Jan 2007 09:49:49 -0800
Message-ID: <1169833789.569762.40220@j27g2000cwj.googlegroups.com>

On Jan 26, 11:34 am, "Paul" <paulwragg2..._at_hotmail.com> wrote:
> >>It is not good enough just to be able to rename the existing constraint
> >>as I need to be able to add new named ones in the future.I'm afraid I looked at that and decided that renaming then wasn't good
> enough, I need to be able to create new named DEFAULT constraints.
>
> Or are you suggesting I create them, obtain the system generated name,
> then rename them?
>
> Thanks

Am I missing something .. or are you trying to say there such thing as "DEFAULT" constraint?
I've heard of column having default values .. but that is not a constraint.

The only constraints I've heard of are Check, PK, FK, Uniq (and not null being a type of check constraint).
Also .. what version of Oracle are you talking about?

Anurag Received on Fri Jan 26 2007 - 11:49:49 CST