aspose file tools*
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
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: 3438
    
  47

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
MySQL table joining
Developing website in English and Arabic
Dynamic creation of custom filter based on the columns visible in the tableColumnHeader
how to get fixed col width in Firefox
JTable Problem