Re: Help with SQL script

From: its not me <it.is_at_not.me.com>
Date: Wed, 27 Jul 2005 13:55:28 +0100
Message-ID: <1vuee159tojk4vne09ggu7qjhv86mqejau@4ax.com>

On 26 Jul 2005 19:17:20 -0700, "Squid" <exceldude2001_at_yahoo.com> wrote:

<-- SNIP -->
As Sybrand mentioned special characters ...

The foreign key Name "FKCustNum" can only be used once, you have used it in both "Packing List" and Drawings and I presume in other places as it fails the first time you attempt to creat it.

To see what constraints exist for the user:

Log on as the user you are trying to create the objects as then:

select *
from user_constraints
where constraint_name = 'FKCUSTNUM'

ALSO NOTE: object names must be unique.
use the view USER_OBJECTS to check for existance of objects with the same name already owned by the user.

(All_objects and All_constraints will also show information) Received on Wed Jul 27 2005 - 07:55:28 CDT