Yashika Bhatia

How to Create a Table With Multiple Foreign Keys in SQL?

Yashika Bhatia

Updated on 17-Mar-2025 316 Views

A foreign key is a field (or collection of fields) in one table that refers to the primary key in another table. The table containing the foreign key is called the child table, and the table containing the primary key is called the parent table. A foreign key ensures that the value in the foreign key column must match a value in the primary key column of the referenced table, maintaining referential integrity between the two tables. Characteristics of a Foreign Key A foreign key creates a relationship between two tables. ...