Re: constraint name: what for?

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Sun, 7 Mar 1999 09:03:26 +0100
Message-ID: <36e232d1$0$19982@pascal>

jerwynn wrote
> Can anyone explain the user of a constraint name

>Isn't it that Oracle autogenerates an identifier/constraint_name
>if you do not specify it?

True, but then your errors also show this auto-generated name.

>I learned that it is necessary to supply a constraint_name
>when specifying a PRIMARY KEY table constraint.

The following syntax is allowed as well:

    create table employee (

        id number(3),
        name varchar2(30),
        primary key(id, name)

    );

Arjan. Received on Sun Mar 07 1999 - 02:03:26 CST