Re: Named constraints

From: Jurij Modic <jmodic_at_src.si>
Date: Thu, 19 Nov 1998 22:06:06 GMT
Message-ID: <36548d6a.13170855@news.siol.net>

On Thu, 19 Nov 1998 10:41:34 -0500, 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?

Their namespace is schema. The constraint names must be unique within the schema. The same is true for indexes, triggers, clusters and private db links.

>Roy Smith <roy_at_popmail.med.nyu.edu>
>New York University School of Medicine

HTH, Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Thu Nov 19 1998 - 16:06:06 CST