foreign key constraint

Bernard Devlin bdrunrev at gmail.com
Mon Jan 25 05:48:55 CST 2010


ALTER TABLE Phone(
    ADD CONSTRAINT 'link_Person_Phone'
        FOREIGN KEY (PersonPtr) REFERENCES Person(ID)
        ON DELETE SET NULL
        ON UPDATE SET NULL )

The above is from the Valentina wiki.  Is that right?  When I try to
use the SQL Editor in VStudio, it complains about unexpected tokens.

Can ID in the refrenced table be a primary key of that table?  Can ID
in the referenced table actually be the RecID of that record in the
table?

I started using binary links but I've given up on those.  They seem to
cause to many problems.

Bernard


More information about the Valentina mailing list