Re: CONSTRAINT keyword in Oracle 8.0

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 Sun Jan 17 1999 - 20:58:48 CST