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 JDBC and the fly likes Can we make any column in nested table as foreign key of a normal table primary 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 » Databases » JDBC
Bookmark "Can we make any column in nested table as foreign key of a normal table primary key?" Watch "Can we make any column in nested table as foreign key of a normal table primary key?" New topic
Author

Can we make any column in nested table as foreign key of a normal table primary key?

Brahim Bakayoko
Ranch Hand

Joined: Aug 29, 2003
Posts: 155
Can we make any column in nested table as foreign key of a normal table primary key?

I know how to set a nested table column as a primary key:
NESTED TABLE Specs STORE AS nested_table_specs((PRIMARY KEY(NESTED_TABLE_ID, SpecID, ...)))

How is it done for foreign keys?


SCJP, SCWCD, SCBCD, IBM CSD WebSphere v5, <br />A+, MCP 2000 and 2000 server, CST, and few incompleted certification tracks.<br /> <br />Ivory Coast<br /> <br />Analyze your web Request/Response @ <a href="http://webtools.servehttp.com" target="_blank" rel="nofollow">http://webtools.servehttp.com</a> down for a while...
 
wood burning stoves
 
subject: Can we make any column in nested table as foreign key of a normal table primary key?
 
Similar Threads
inserting data of two forms into two tables with same transaction id
How to implement OneToOne entity without explicit id field
Generator class for non-primary columns
hibernate mapping
Composite foreign key mapping in Hibernate 3 using JPA