Explain the difference between the foreign key and the referenced key.
Foreign Key | Reference key |
---|---|
The foreign key is used to connect the secondary table to the primary table. | A reference key is a primary key that is mainly used to create column level constraints. |
It helps the database to connect two whole tables with a common constraint. | It is not applicable to the whole table. |
BY Best Interview Question ON 25 Oct 2019