Yes. We can create a Foreign key without having Primary key in the parent table. Most of us are in a misconception that we can not create a Foreign key without primary key in the parent table. Also most of the books
Primary key: It Identifies each and every record uniquely We can create only one Primary key on a table Primary keys do not accept NULL values It creates a clustered index in the table by default Foreign key: It makes the relation
Foreign key Foreign key is a field or combination of fields which matches its values with a Primary key in another table. That means, foreign key is like a link between two tables. This is also called as a Referencing key.