This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach 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 Murach's Java Servlets and JSP this week in the Servlets 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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
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