Re: Named constraints

From: <alex_n_at_equinoxlt.com>
Date: Fri, 20 Nov 1998 16:52:41 GMT
Message-ID: <7346of$shg$1@nnrp1.dejanews.com>

No you can't create two constraints with the same name in a schema. You'll get:
ORA-02264: name already used by an existing constraint

Alex

In article <roy-1911981041340001_at_qwerky.med.nyu.edu>, roy_at_popmail.med.nyu.edu (Roy Smith) wrote:
> What namespace do constraint names exist in? What I mean is, do they have
> to be unique within the schema (like table names) or do they just have to
> be unique within a given table (like column) names?
>
> --
> Roy Smith <roy_at_popmail.med.nyu.edu>
> New York University School of Medicine
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Nov 20 1998 - 10:52:41 CST