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

Home -> Community -> Usenet -> c.d.o.misc -> Re: CONSTRAINT keyword in Oracle 8.0

Re: CONSTRAINT keyword in Oracle 8.0

From: Keith Jamieson <pdkj02_at_email.mot.com>
Date: Mon, 18 Jan 1999 09:09:40 +0000
Message-ID: <36A2FA53.36FD8E3D@email.mot.com>


Yes, it is possible, however I prefer to name my constraints myself. If you come up with a good naming scheme for the constraints, debugging can be a lot easier.

John Koo wrote:

> Sandeep Rajkumar wrote:
> >
> > Hello,
> >
> > I wonder if someone could tell me whether the CONSTRAINT keyword
> > is necessary to define a entity, key or referential integrity constraint
> > when creating a table in an Oracle 8 database. Isn't it possible to
> > create a table in the old way:
> >
> > CREATE TABLE Customer
> > (custID VARCHAR(6) NOT NULL UNIQUE,
> > custName VARCHAR(50) NOT NULL,
> > custPhone VARCHAR(20) NOT NULL,
> > custAddr VARCHAR(100) NOT NULL,
> > PRIMARY KEY(custID));
> >
> > instead of using the CONSTRAINT keyword to define and name
> > each constraint in a table?
> >
> > S. Rajkumar.
>
> You might be interest to know there are TWO different syntax to solve the
> SAME problem. Both of them are VALID! Did I answered your question ?
>
> John Koo
> johnkoo_at_i-wave.net
Received on Mon Jan 18 1999 - 03:09:40 CST

Original text of this message

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