Re: Named constraints

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 22 Nov 1998 00:04:11 GMT
Message-ID: <3668301c.5496675@netnews.worldnet.att.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?

Constraint names do need to be unique within a schema, not within a table. I'm not sure if they share namespace with tablenames. I don't believe they do, but I would have to test it to be sure.

Jonathan Received on Sat Nov 21 1998 - 18:04:11 CST