What is primary key and foreign key in sql?

Question

Could someone tell me what is primary key and foreign key in SQL?

Answer 1

Primary the key could be defined as a column or any set of columns that hold a unique value and identify a single row.

Whereas, a foreign key is defined as a column or set of columns in a table that acts as a reference for the primary key in another table.

If you are interested in learning SQL? Then I would suggest you check out the SQL certification from Intellipaat that is co-created with Microsoft!

Also, do watch our video from experts on the SQL tutorial to gain more insight.