Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Named constraints
Roy,
constraints have their own namespace. This means, that constraint names must
be unique within the schema.
The reason lies within the way constraints are implemented in the database.
If you look at de data dictionary view called user_constraints, you can see
that i.e. foreign keys only contain a reference to another constraint (using
the cols r_owner and r_constraint_name) and NOT a table name. The server
than looks at the referenced constraint to find out which table belongs to
it.
Hope this helps
Jac.
Roy Smith wrote in message ...
>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
>
Received on Thu Nov 19 1998 - 15:01:35 CST