aspose file tools*
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
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...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Can we make any column in nested table as foreign key of a normal table primary key?