← Prev in month
← Prev in thread
Next in thread →
Next in month →
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
← Prev in month
← Prev in thread
Next in thread →
Next in month →