Now foreign key relationships can be managed via the UI in Server Explorer, as two new pages have been added to the Table Properties dialog:
This is the "classic" dialog from SQL CE 3.1
(click to enlarge)
Notice the two new pages, a "Add Relations" page.
And a "Manage Relations" page.
This is a nice addition to the SQL Compact Management UI - and is a missing piece requested by many users.