Question

A non-foreign key cannot be referenced in a path expression

Answer 1

Yes, you can have a primary key without a clustered index - and sometimes, you may want to (for instance when your primary key is a combination of foreign.

Answer 2

Answer:

hope this answer useful to you mate