foreign key constraint

Ruslan Zasukhin ruslan_zasukhin at valentina-db.com
Mon Jan 25 13:39:45 CST 2010


On 1/25/10 7:06 PM, "Bernard Devlin" <bdrunrev at gmail.com> wrote:

> Since there is no way to examine the binary links using VStudio (i.e.
> how many links in db, which records they are supposed to be pointing
> to, etc) , I decided to just use SQL only.

Indirectly this is possible todo with this SQL

SELECT T1.recid, T2.recid
FROM T1 join T2 using link_1

This should give cursor of two columns as

1 3
1 5
2 6
2 9 


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]




More information about the Valentina mailing list