Re: question about constraint
From: SuBrAhMaNyAm <skorisapati_at_worldbank.org>
Date: 1996/04/29
Message-ID: <3184BA25.456B_at_worldbank.org>#1/1
Date: 1996/04/29
Message-ID: <3184BA25.456B_at_worldbank.org>#1/1
MCC wrote:
>
> What is the purpose of having a CONSTRAINT in the following statement:
>
> CREATE TABLE s_ord
> (id NUMBER(7),
> customer_id NUMBER(7)
> CONSTRAINT s_ord_customer_id nn NOT NULL,
> .
> .
> .
> );
>
> why can't we just define customer_id to NUMBER(7) NOT NULL?
> Thanks,
> Duffy
For
- Ease of use to alter, drop constraint
- Documentation