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

What is the foreign key constraint and what is the need of it on a Table?

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.  

Read More