Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

The Basics of Creating Tables in SQL

Introduction
1. Foreign Keys – Introduction
Foreign keys
Multi-column Foreign Keys
Summary

Instruction

Hello, it's nice to see you again! The last time around, we talked about primary keys and the NOT NULL constraint. Strictly speaking, the constructs we've discussed previously kept data accurate in single tables.

This time, we're going to talk about another kind of constraint that deserves an entire part of its own. The topic will be constraints that keep data between different tables accurate. Such constraints are called foreign keys (or FK for short).

Exercise

Click the Next exercise button to continue the introduction.