Re: Foreign Key Constraint
From: joel garry <joel-garry_at_home.com>
Date: Fri, 15 Jul 2011 10:57:59 -0700 (PDT)
Message-ID: <7eae52a8-f75d-4927-b3a0-51e53ffa88f9_at_p12g2000pre.googlegroups.com>
On Jul 15, 6:44 am, The Magnet <a..._at_unsu.com> wrote:
> Hi,
>
> I need to make a FK constraint, but it is against a table where the
> column is not a PK, can this be done?
>
> Table1:
> Customer ID \ Composite Primary Key
> Portfolio ID / Composite Primary Key
>
> Table 2:
> Portfolio ID: Non unique and must exist in Table 1
>
> Thanks!
Date: Fri, 15 Jul 2011 10:57:59 -0700 (PDT)
Message-ID: <7eae52a8-f75d-4927-b3a0-51e53ffa88f9_at_p12g2000pre.googlegroups.com>
On Jul 15, 6:44 am, The Magnet <a..._at_unsu.com> wrote:
> Hi,
>
> I need to make a FK constraint, but it is against a table where the
> column is not a PK, can this be done?
>
> Table1:
> Customer ID \ Composite Primary Key
> Portfolio ID / Composite Primary Key
>
> Table 2:
> Portfolio ID: Non unique and must exist in Table 1
>
> Thanks!
"Primary or unique" http://download.oracle.com/docs/cd/E11882_01/server.112/e16508/datainte.htm#CNCPT1649
Look in asktom for common problems with fk's.
jg
-- _at_home.com is bogus. http://www.bloomberg.com/news/2011-07-15/amazon-com-infant-no-more-should-be-charging-sales-tax-view.htmlReceived on Fri Jul 15 2011 - 12:57:59 CDT