Re: Naming not null constraints in Case 5.1beta

In <3fh0nr$rg_at_lll-winken.llnl.gov> 68a869_at_llnl.gov (Jeff Busch) writes:

>
>When we generate DDL from case 5.1 beta, the not null constraints are
>all named SYS_blah_blah_blah. We would like to be able to name them.
>We can name the primary key, foreign key constraints, etc.
>
>Does anyone know where in case to name the not null constraints?
>
>---
>Jeff Busch Internet busch1_at_llnl.gov
>Voice (510) 423-9134 Fax (408) 263-1360
>

There isn't any place to name them. Why do you want to?

You don't need the name to get rid of NOT NULL constraints (unlike PK & FK, where you do need them). And you can't DISABLE them.

-JJ

 Jeffrey Jacobs & Associates
 Oracle CASE Consulting and Training
 951-2 Old Country Road, Suite 119
 Belmont, CA 94002
 Voice: 415-571-7092
 FAX: 800-665-1379
 CompuServe: 76702,456
 Internet: jjacobs_at_well.com
 Internet: jmjacobs_at_ix.netcom.com     Received on Wed Jan 18 1995 - 09:09:47 CET