Table Relationships
Learn about the different types of relationships that can exist between tables.
We'll cover the following...
A relationship is when one column of one table references another column in a different table. For example, we can have a table called Orders that contains a column ItemId that references the Id column of the Items table.
A table that references another table is called a child table. The table that is being referenced is called a parent table. In our example above, Items is the parent table referenced by the Orders table.
Foreign keys
To create a relationship, we use the concept of foreign keys, a term used to describe ...