This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes Multiple columns having same foreign key Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Multiple columns having same foreign key" Watch "Multiple columns having same foreign key" New topic
Author

Multiple columns having same foreign key

Jayavardhan geepi
Ranch Hand

Joined: Jul 21, 2010
Posts: 66
Hi..

In a table I have 2 columns which must refer to same column of another table.

while Executing alter table query for 2nd column it says such a constraint already exists.

Can some one help.. Is this possible?
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3606
    
  60

Yes, it should be possible, like this:
Post your script and error messages if you cannot resolve it.
 
Consider Paul's rocket mass heater.
 
subject: Multiple columns having same foreign key
 
Similar Threads
Dynamic creation of custom filter based on the columns visible in the tableColumnHeader
MySQL table joining
how to get fixed col width in Firefox
Developing website in English and Arabic
JTable Problem