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