Foreign Key Constraint

#1

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!

#2

On Jul 15, 6:44*am, The Magnet <a... (AT) unsu (DOT) com> wrote:

Quote:

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/E....htm#CNCPT1649

Look in asktom for common problems with fk's.

jg
--
@home.com is bogus.
http://www.bloomberg.com/news/2011-0...-tax-view.html

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Foreign Key Constraint

comp.databases.oracle.misc comp.databases.oracle.misc

Foreign Key Constraint - 07-15-2011 , 08:44 AM

Re: Foreign Key Constraint - 07-15-2011 , 12:57 PM