Is it possible to create a Foreign key without Primary key?

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

Read More

What is the difference between Primary key and Foreign key?

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

Read More