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


Win a copy of Head First Android 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: 3717
    
  61

Yes, it should be possible, like this:
Post your script and error messages if you cannot resolve it.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Multiple columns having same foreign key
 
It's not a secret anymore!