XML.orgXML.org
FOCUS AREAS |XML-DEV |XML.org DAILY NEWSLINK |REGISTRY |RESOURCES |ABOUT
OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index]
FK between rational and xml, between xml and xml

Good day,

I propose to use XPath in DDL to create foreign keys
[1] from rational to xml

create table a(
  a1 num,
  a2 string
);
create table b(
  b1 num,
  b2 num references a(@a2/k/m/n/@n1)
);

[2] from xml to rational

create table a (
  a1 num,
  a2 num
);
create table b (
  b1 num,
  b2 string
);
alter table b add foreign key (@b2/k/m/n/@n1) references a(a2);

[3] from xml to xml

create table a (
  a1 num,
  a2 string
);
create table b (
  b1 num,
  b2 string
);
alter table b add foreign key (@b2/k/m/n/@n1) references a(@a2/p/q/r/@r1);



Dmitry Turin
SQL5      (5.7.0)  http://sql50.euro.ru
HTML6     (6.5.0)  http://html60.euro.ru
Unicode7  (7.2.1)  http://unicode70.euro.ru
Computer2 (2.0.2)  http://computer20.euro.ru



[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index]


News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 1993-2007 XML.org. This site is hosted by OASIS