How do you add foreign key constraints in SqlCe?  Like this:

ALTER TABLE tablename ADD CONSTRAINT FK__nameofforeignkey FOREIGN KEY (id) REFERENCES tablename(id) ON UPDATE CASCADE

How do you check it’s there?

SELECT * FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS

Install SQLExpress 2008 "Access Denied" Error
Introduction to Composite WPF (CAL, Prism) Part 1

Leave a Comment

Your email address will not be published. Required fields are marked *

CAPTCHA

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.