posted 19 years ago
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...